C# code string str1 = "provider=Microsoft.Jet.OLEDB.4.0;Data source=student1.mdb;User Id=admin;Jet OLEDB:Database Password=admin";
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=’" + textBox1.Text.Trim() + "‘ where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("密码修改成功!");这段代码 错哪里了 为什么老是说update语法错误!是access数据库!
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=’" + textBox1.Text.Trim() + "‘ where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("密码修改成功!");这段代码 错哪里了 为什么老是说update语法错误!是access数据库!
string str4 = "update logn set password=''" + textBox1.Text.Trim() + "'' where id=1";这样看看???是不是你这个符号《’》不对啊
就是报错说 update语法错误