Question

c# Access数据库 出现至少一个参数没有被指定值，代码哪里有问题？

dbconn = new OleDbConnection(@"provider=microsoft.jet.oledb.4.0; Data Source=d:\Database1.mdb");
dbconn.Open();
string sql = "update [ar_user] set [password]= '123' where [username]= [Admin]";
//
OleDbCommand comm = new OleDbCommand(sql, dbconn);
comm.ExecuteNonQuery();
dbconn.Close();
数据库表 ar_user。

Answer 1

你的SQL语句有问题,把string sql = "update [ar_user] set [password]= '123' where [username]= [Admin]";改为string sql = "update [ar_user] set [password]= '123' where [username]= 'Admin'"