asp.net不能修改access数据库中的记录

2025-03-10 16:29:36

推荐回答（3个）

回答1：

参数不正确....
string sqlinfo = "UPDATE [systemuser] SET [sex]='" + sex + "'," + "[address]='" + address + "'," + "[jiguan]='" + jiguan + "'," + "[minzu]='" + minzu + "'," + "[tel]='" + tel + "'," + "[mobile]='" + mobile + "'," + "[hunfuo]='" + hunfuo + "'," + "[shengri]='" + shri + "'," + "[idcard]='" + idcard + "'," + "[age]=" + age + "," + "[bank]='" + bank + "'," + "[banknumber]='" + banknumber + "' where [id]=" + updatid;
OleDbCommand infocmd = new OleDbCommand(sqlinfo, conn);

infocmd.ExecuteNonQuery();

回答2：

把你的代码贴出来瞅一眼再分析吧...极大可能是你的update语句写的有问题...你可以把你的sql语句放到access的"查询分析器"里执行下...

回答3：

有主键么？