C# Access Update 注意事项

private const string ACCESS_UPDATE_ADMIN_PASSWORD = "UPDATE [Admins] SET admin_pass=@adminPass WHERE admin_name=@adminName";

 

dbInstance.SetParameters("@adminPass", _adminDObj.Admin_Password);
dbInstance.SetParameters("@adminName", _adminDObj.Admin_Name);

参数的顺序必须和SQL的顺序一直，否则无法更新。如上面这2行颠倒了，则会无法更新