Question

C# checkboxlist 写入数据库的问题

SqlConnection conn = new SqlConnection("server=(local);database=SimpleVote;uid=sa;pwd=");
conn.Open();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
SqlCommand add = new SqlCommand("update VoteItem set ItemCount=ItemCount+1", conn);
if (CheckBoxList1.Items[i].Selected==true)
add.ExecuteNonQuery();
}
想用checkboxlist做一个投票系统，什么我做的有选中项的时候提交，所有项（包含没有被选中的项）的ItemCount（计算次数）增加了。应该怎样修改啊，请教各位高手。谢谢

Answer 1

SqlConnection conn = new SqlConnection("server=(local);database=SimpleVote;uid=sa;pwd=");
conn.Open();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected){
SqlCommand add = new SqlCommand("update VoteItem set ItemCount=ItemCount+1", conn);

add.ExecuteNonQuery(); }
}

Answer 2

你写的是增加了之后再判断的当然是全增加了

你那个判断就根本没用上
SqlConnection conn = new SqlConnection("server=(local);database=SimpleVote;uid=sa;pwd=");
conn.Open();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{if (CheckBoxList1.Items[i].Selected==true)
SqlCommand add = new SqlCommand("update VoteItem set ItemCount=ItemCount+1", conn);

add.ExecuteNonQuery();
}
这个样子应该差不多了

Answer 3

老子无语！
if (CheckBoxList1.Items[i].Selected==true)
add.ExecuteNonQuery();
怎么有没有
if (CheckBoxList1.Items[i].Selected==true)
{
add.ExecuteNonQuery();
}
还是你打少了？

Answer 4

update VoteItem set ItemCount=ItemCount+1没有where 条件当然都增加了