看看下面的例子:
public static void UpdateUserName(AdminInfo admininfo)
{
string sqlstr = "update T_Admin set AdminName=@AdminName where Id=@Id";
DBHelp.GetExecuteNonQuery(sqlstr,new OleDbParameter("@Id",admininfo.Id),new OleDbParameter("@AdminName", admininfo.AdminName));
}
最后没执行任务操作
参数顺序换过之后:
public static void UpdateUserName(AdminInfo admininfo)
{
string sqlstr = "update T_Admin set AdminName=@AdminName where Id=@Id";
DBHelp.GetExecuteNonQuery(sqlstr,new OleDbParameter("@AdminName", admininfo.AdminName),new OleDbParameter("@Id",admininfo.Id));
}
执行了操作
可见参数位置也很重要,晕死