Question

asp.net sql语句更新传参数

代码 string sqlstr = " update RoomInfo set RoomInfo.CommomFreeCount=RoomInfo.CommomFreeCount-@number Address=@Address ";
SqlCommand cmd = new SqlCommand(sqlstr, conn);

SqlParameter num = new SqlParameter("@number",int.Parse(RoomOrderNum.Text));
SqlParameter address = new SqlParameter("@Address", Session["InsertHotelAddress"].ToString());
cmd.Parameters.Add(address);
cmd.Parameters.Add(num);
正确格式应该是怎样的啊 老是写不对

Answer 1

string sqlstr = " update RoomInfo set RoomInfo.CommomFreeCount=RoomInfo.CommomFreeCount-@number 
where Address=@Address ";  

SqlCommand cmd = new SqlCommand(sqlstr, conn);
cmd.Parameters.AddWithValue("@number"，int.Parse(RoomOrderNum.Text));
cmd.Parameters.AddWithValue("@Address"，Session["InsertHotelAddress"].ToString());

你的sql语句address那边不太对。

Answer 2

参数语法，应该是对的。

update语句有问题，
update RoomInfo set RoomInfo.CommomFreeCount=RoomInfo.CommomFreeCount-@number,Address=@Address

你少了一个“,”

Answer 3

select top (@num) * from 必须加小括号