MS-Access更新问题 [英] Ms-Access update problem

问题描述

HI大家好，这是我的代码.如果我尝试用注释的部分将其赋予异常Somehting作为错误的更新语法.请帮助...如果我在不使用密码的情况下对该查询进行注释，请尝试...字符串{path1 = System.Configuration.ConfigurationManager.AppSettings.Get(数据库路径"); OleDbConnection con =新的OleDbConnection("PROVIDER = Microsoft.Jet.OLEDB.4.0; DATA SOURCE =" + path1); con.Open(); //OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname = @ Firstname，Lastname = @ Lastname，Address = @ Address，City = @ City，County = @ County，Password = @ Password，Comments = @ Comments WHERE ID =" + uID.Text +"，con); OleDbCommand cmd =新的OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname = @ Firstname，Lastname = @ Lastname，Address = @ Address，City = @ City，County = @ County，Comments = @ Comments，其中ID = + uID.Text +""，con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ Firstname"，txtFirstName.Text); cmd.Parameters.AddWithValue("@ Lastname"，txtLastName.Text); cmd.Parameters.AddWithValue("@ Address"，txtAddress.Text); cmd.Parameters.AddWithValue("@ City"，txtCity.Text); cmd.Parameters.AddWithValue("@ County"，txtState.Text); //cmd.Parameters.AddWithValue("@Password，txtPassword.Text); cmd.Parameters.AddWithValue("@ Comments"，txtcomments.Text); cmd.ExecuteNonQuery(); con.Close(); con = null; } catch(Exception ex){txtFirstName.Text = ex.Message; }

HI Everybody here is my code..If I try with commented part its giving exception Somehting as Incorrect Update Syntax..please help...If i comment that query without password its working fine... try { string path1 = System.Configuration.ConfigurationManager.AppSettings.Get("databasepath"); OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + path1); con.Open(); // OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname=@Firstname, Lastname=@Lastname,Address=@Address,City=@City,County=@County,Password=@Password,Comments=@Comments WHERE ID=" + uID.Text + "", con); OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname=@Firstname, Lastname=@Lastname,Address=@Address,City=@City,County=@County,Comments=@Comments WHERE ID=" + uID.Text + "", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Firstname", txtFirstName.Text); cmd.Parameters.AddWithValue("@Lastname", txtLastName.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.Parameters.AddWithValue("@City", txtCity.Text); cmd.Parameters.AddWithValue("@County", txtState.Text); //cmd.Parameters.AddWithValue("@Password", txtPassword.Text); cmd.Parameters.AddWithValue("@Comments", txtcomments.Text); cmd.ExecuteNonQuery(); con.Close(); con = null; } catch (Exception ex) { txtFirstName.Text = ex.Message; }

推荐答案

嗨拉迪卡

您的注释更新声明，仅缺少单个报价，请使用下一行并检查是否已解决问题

Hi Radhika

YOUR COMMENTED UPDATE STATEMENT , ONLY THE SINGLE QUOTES ARE MISSING ,USE THE BELOW LINE AND CHECK IF THE PROBLEM IS SOLVED

OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname=@Firstname, Lastname=@Lastname,Address=@Address,City=@City,County=@County,Password=@Password,Comments=@Comments WHERE ID=''" + uID.Text + "''", con);

是的，我解决了我的问题.``密码''是ms-access中的受限密钥.因此，它没有更新...我们需要放置所有方括号中的字段，然后它就可以工作..like

"UPDATE codefixermp_tblMembers SET [Firstnam] e = @ Firstname，[Lastname] = @ Lastname，[Address] = @ Address，[City] = @ City，[County] = @ County，[Password] = @ Password .... ..

yes,I resolve my issue..''Password'' is a restricted key in ms-access.So,its not getting updated...We need to place all the fields with in square-bracket then it works..like

"UPDATE codefixermp_tblMembers SET [Firstnam]e=@Firstname, [Lastname]=@Lastname,[Address]=@Address,[City]=@City,[County]=@County,[Password]=@Password......

这篇关于MS-Access更新问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！