这是Update语句:
Update UserInfo Set UserName=@UserName,EmailURL=@EmailURL,PassWord,=@PassWord,LoggingTime=@LoggingTime,UserType=@UserType Where UserID=@UserID
这是程序语句:
public string UpdateUserInfoByUserID(UserInfo userInfo)
{
string sql_Update = " Update UserInfo Set UserName=@UserName,EmailURL=@EmailURL,PassWord,=@PassWord,LoggingTime=@LoggingTime,UserType=@UserType Where UserID=@UserID";
OleDbParameter[] params_Update = new OleDbParameter[]
{
OleDbHelper.MakeInParam("@UserName",OleDbType.VarWChar,userInfo.UserName),
OleDbHelper.MakeInParam("@EmailURL",OleDbType.VarWChar,userInfo.EmailURL),
OleDbHelper.MakeInParam("@PassWord",OleDbType.VarWChar,userInfo.PassWord),
OleDbHelper.MakeInParam("@LoggingTime",OleDbType.Date,userInfo.LoggingTime),
OleDbHelper.MakeInParam("@UserType",OleDbType.BigInt,userInfo.UserType),
OleDbHelper.MakeInParam("@UserID",OleDbType.BigInt,userInfo.UserID)
};
returnOleDbHelper.ExecuteNonQuery(connString,sql_Update,params_Update).ToString();
}
下图是表的构造:
总是提示Update语句语法错误
把字段都改成类似 UserInfo.[UserID]=@UserID 这样也不行
把sql语句改成:
Update UserInfo Set
PassWord,=@PassWord,LoggingTime=@LoggingTime,UserType=@UserType Where UserID=@UserID
就不会报错了 但是数据库没更新 似乎这个sql语句根本就没有执行
那位大侠帮帮忙呀 郁闷死我了
|