Question

c#修改access数据库，这条指令总是提示updata有错误，实在看不出了，请高手帮忙

if (comboBox1.Text != "")
{
string mysql = "update jiaoshixinxi set identity ='" + comboBox1.Text.Trim() + "'where teacherid = '" + textBox4.Text.Trim() + "'";
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = mysql;
cmd.Connection = jiaoshi.myConn1;
cmd.ExecuteNonQuery();
tag = 1;
}

Answer 1

1、连接是打开的吧。
2、identity的类型是字符串的吗？如果是字符串的，那长度是否小于等于你comboBox1.Text.trim()里的数据？

Answer 2

非字符串值是不用加单引号的，你看看你的数据库字段类型

Answer 3

where前加个空格试试？
string mysql = "update jiaoshixinxi set identity ='" + comboBox1.Text.Trim() + "' where teacherid = '" + textBox4.Text.Trim() + "'";