Question

ASP.NET数据更新问题~？

private void btnVote_Click(object sender, System.EventArgs e)
{
SqlConnection con=DB.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandText="update voteDetails set voteNum=voteNum+1 where voteID=" + voteID + " and voteDetailsID" + this.rbtnItems.SelectedValue.ToString();
cmd.ExecuteNonQuery();//显示这个地方附近有错误，请高手帮我看看~谢谢
con.Close();
}

Answer 1

对,and voteDetailsID" + this.rbtnItems.SelectedValue.ToString();
这里少了一个=!
应该这样
and voteDetailsID=" + this.rbtnItems.SelectedValue.ToString();

Answer 2

cmd.CommandText="update voteDetails set voteNum=voteNum+1 where voteID=" + voteID + " and voteDetailsID" + this.rbtnItems.SelectedValue.ToString();
应该是你这句拼出来的sql有问题
voteDetailsID后边是不是应该有等号啊？

Answer 3

应该是的

cmd.CommandText="update voteDetails set voteNum=voteNum+1 where voteID=" + voteID + " and voteDetailsID=" + this.rbtnItems.SelectedValue.ToString();