急!!!!!Update语句错误,很简单的,求帮忙
protected void updateMoney(OleDbConnection OleDbcon)
{
OleDbConnection conn = DB.connstr();
conn.Open();
string updateM = "select Money from user_info where userName='" + Session["user"].ToString() + "'";
OleDbCommand updcmd = new OleDbCommand(updateM, OleDbcon);
double allM = Convert.ToDouble(updcmd.ExecuteScalar());
string newM = Convert.ToString(allM - Convert.ToDouble(this.CartPriceTxt.Text));
string uped = "update user_info set Money='" + newM + "' where userName='" + Session["user"].ToString() + "'";
OleDbCommand upcmd = new OleDbCommand(uped, OleDbcon);
upcmd.ExecuteNonQuery();
conn.Close();
}
就是购买之后,更新金币数量,但是执行时报错。
以下是表结构,最简单的Access表,表名use_info,字段useID为主键,自动编号,Money为文本类型,useName也是文本