62,041
社区成员
发帖
与我相关
我的任务
分享
public void Vote(int number,int id)
{
//OleDbCommand comr = new OleDbCommand("SELECT @vl FROM [topics WHERE [ID]=@id", con);
//comr.Parameters.Add("@vl", "vl" + number);
//comr.Parameters.Add("@id", id);
OleDbCommand com = new OleDbCommand("UPDATE [topics] SET [@vl]=[@vl]+1 WHERE [ID]=@id",con);
com.Parameters.Add("@vl", "vl" + number.ToString());
OleDbParameter par = new OleDbParameter("@id", OleDbType.Integer);
par.Value = id;
com.Parameters.Add(par);
con.Open();
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
Vote(int.Parse(par.Substring(5,1)),int.Parse(Request.QueryString["id"]));
UPDATE [topics] SET [vl字段名]=[@vl]+1 WHERE [ID]=@id