public bool PollCastVote(int PollAnswerID) { bool returnValue = false; Guid userID = Guid.NewGuid(); DateTime dateTimeStamp = DateTime.Now; // connection string string connectionString = ConfigurationManager.ConnectionStrings["PollConnectionString"].ConnectionString; // Sql connection object initialized with connection string used to connect using (SqlConnection mySqlConnection = new SqlConnection(connectionString)) { try { // open the Sql connection mySqlConnection.Open(); // Sql Command object initialized with SQL INSERT SqlCommand mySqlCommand = new SqlCommand("INSERT INTO PollUserResponses (UserID, PollAnswerID, DateTimeStamp) VALUES (@UserID, @PollAnswerID, @DateTimeStamp)", mySqlConnection); mySqlCommand.Parameters.AddWithValue("@UserID", userID); mySqlCommand.Parameters.AddWithValue("@PollAnswerID", PollAnswerID); mySqlCommand.Parameters.AddWithValue("@DateTimeStamp", dateTimeStamp); // Execute mySqlCommand.ExecuteNonQuery(); returnValue = true; } catch (Exception ex) { } finally { // close the Sql Connection mySqlConnection.Close(); } return returnValue; } }