protected void SaveButton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("data source=.; database=HolmenRoboticsClub; integrated security=SSPI"); try { //insert an event record into the database along with the attendees for the event Int32 newProdID = 0; SqlCommand cmd = new SqlCommand("insert into Event (Title,Description,StartTime,EndTime,StartDate,EndDate) Values(@Title, @Description, @StartTime, @EndTime, @StartDate,@EndDate)" + "SELECT CAST(scope_identity() AS int)", con); cmd.Parameters.AddWithValue("@Title", TitleTextBox.Text); cmd.Parameters.AddWithValue("@Description", DescriptionTextBox.Text); cmd.Parameters.AddWithValue("@StartTime", StartTime.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@EndTime", EndTime.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@StartDate", StartDayTextBox.Text); cmd.Parameters.AddWithValue("@EndDate", EndDayTextBox.Text); con.Open(); newProdID = (Int32)cmd.ExecuteScalar(); //get the new id for the event attendees = (List <string>)Session["Attendees"]; //get the attendees from session state variable foreach (string name in attendees) { SqlCommand cmd2 = new SqlCommand("insert into Attendees(Name,EventID) Values(@Name,@EventID)", con); cmd2.Parameters.AddWithValue("@Name", name); cmd2.Parameters.AddWithValue("@EventID", newProdID); cmd2.ExecuteNonQuery(); } EventsGridView.DataBind(); } catch (Exception error) { Response.Write(error.Message); } finally { con.Close(); } }
private void EventsGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { EventsGridView.ClearSelection(); }