UC知道Update语句语法错误（Access）
来源：百度知道 编辑：UC知道 时间：2024/07/18 13:58:31
这是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),
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),
是不是这两个的类型有问题：UserName=@UserName,EmailURL=@EmailURL，或者你传进来的userInfo有问题，数据库没更新可能是你那ID数据库里根本就没有
你PassWord后面有个,号：PassWord,=@PassWord，该不会你程序里也有吧！