Question

C# 先连接Access数据库，然后查询内容、更新内容，提示UPDATE语法错误，可是语句在Access中可正常执行

部分代码如下 ：
CommandString = "SELECT password FROM LogInData WHERE username=";
CommandString = String.Format("{0}'{1}'", CommandString, textBox1.Text.Trim());
DataBaseConnectionHandle = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.146.91.190\TeamData\TeamData.mdb");
DataBaseConnectionHandle.Open();
OleDbCommand CommandHandle = DataBaseConnectionHandle.CreateCommand();
CommandHandle.CommandText = CommandString.ToString();
OleDbDataReader DataReader = CommandHandle.ExecuteReader();
DataReader.Close();
CommandHandle.Dispose();
CommandHandle = DataBaseConnectionHandle.CreateCommand();
CommandString = "UPDATE LogInData SET password=";
CommandString = String.Format("{0}'{1}'", CommandString, textBox2.Text.Trim());
CommandString += " WHERE username=";
CommandString = String.Format("{0}'{1}'", CommandString, textBox1.Text.Trim());
CommandHandle.CommandText = CommandString.ToString();
CommandHandle.ExecuteNonQuery()

Answer 1

Access中你是否没有用自动编号当做主键？这种情况会发生你说的问题
where条件处必须是自动编号主键