protected void Poll1_Voting(object sender, PollItemEventArgs e)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
foreach (PollAnswer answer in Poll1.Answers)
{
if (answer.Selected)
{
string logVoteQuery = "UPDATE Answers SET Votes = Votes + 1 WHERE AnswerID = @AnswerID";
SqlCommand logVoteCommand = new SqlCommand(logVoteQuery, conn);
logVoteCommand.Parameters.AddWithValue("@AnswerID", answer.Item.Value);
logVoteCommand.ExecuteNonQuery();
break;
}
}
conn.Close();
}