小白请教大神一个问题 谢谢
string mystr, mysql;
OleDbConnection myconn=new OleDbConnection();
OleDbCommand mycmd=new OleDbCommand ();
mystr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\school.mdb";
myconn.ConnectionString = mystr;
myconn.Open();
mysql ="update ksb set 是否领取='1' from ksb where sfzh='330522199709124346'";
mycmd.CommandText = mysql;
mycmd.Connection = myconn;
mycmd.ExecuteNonQuery();
myconn.Close();
提示SQL语句出现了问题,语法错误 (操作符丢失) 在查询表达式 ''1' from ksb' 中
要怎么改写啊