为什么更改不了数据,请帮忙看看代码。
想做一个更改用户密码的功能,数据库里面的表user有两个字段和两条记录:
usename password
zx 666666
aaa 888888
linq_ddglDataContext xg = new linq_ddglDataContext();
var u = xg.GetTable<user>();
var a = from bb in u where bb.usename == "aaa" select bb;
foreach (var c in a)
{
c.password = "123";
}
xg.SubmitChanges();
MessageBox.Show("已经更改");