asp.net修改投票结果问题？？？

显示全部楼层 · 2009-4-5 00:38:21

以下是一小段代码：
public void UpdateVote(int VoteID)

{

string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;

OleDbConnection myConnection = new OleDbConnection(myConnectionString);

string UpdateVoteInfo = "update Vote set NumVote=NumVote+1 where VoteID='"+this.RadioButtonList1.SelectedValue+"'";

myConnection.Open();

OleDbCommand cmd = new OleDbCommand("UpdateVoteInfo", myConnection);

cmd.ExecuteNonQuery();//这里显示说“无效sql语句”，不知道怎么回事？？

cmd.Dispose();

myConnection.Close();

}
string UpdateVoteInfo = "update Vote set NumVote='"+NumVote+1+"' where VoteID='"+this.RadioButtonList1.SelectedValue+"'";
改成这样不对啊，因为NumVote没有定义。NumVote是数据库的字段。不用定义啊

千问 · 2009-4-5 00:38:21

OleDbCommand cmd = new OleDbCommand("UpdateVoteInfo", myConnection); cmd.ExecuteNonQuery();//这里显示说“无效sql语句”，不知道怎么回事？？当然无效了，把"UpdateVoteInfo"的""去掉...

千问 · 2009-4-5 00:38:21

string UpdateVoteInfo = "update Vote set NumVote='"+NumVote+1+"' where VoteID='"+this.RadioButtonList1.SelectedValue+"'";...