public int UpdateUserPassword(string sname,string spassword)
{
strOleDb = new StringBuilder();
strOleDb.Append("update FinanceUser set ");
strOleDb.Append("name='" + sname + "',password='" + spassword + "'");
strOleDb.Append(" where ID=1"); int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
return i;
}
UPDATE 语句的语法错误。哪里有问题
{
strOleDb = new StringBuilder();
strOleDb.Append("update FinanceUser set ");
strOleDb.Append("name='" + sname + "',password='" + spassword + "'");
strOleDb.Append(" where ID=1"); int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
return i;
}
UPDATE 语句的语法错误。哪里有问题
FinanceUser set name=....
from
tb
where
id=1
FinanceUser 这个就是表名啊
update
FinanceUser set name=....
from
FinanceUse
where
id=1
FinanceUser set name=....
from
FinanceUser
where
id=1
{
strOleDb = new StringBuilder();
strOleDb.Append("update FinanceUser set ");
strOleDb.Append("[name]='" + sname + "',[password]='" + spassword + "'");
strOleDb.Append(" where [ID]=1"); int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
return i;
}
Thank you all the same.