private void uxInsertButton_Click(object sender, EventArgs e) { repo = new SqlPersonRepository("Data Source = mssql.cs.ksu.edu; " + "Initial Catalog=phyo;" + "User id=username;" + "Password=password;"); string name = uxPersonName.Text; string DOB = dateTimePicker1.Value.Date.ToString("yyyy-MM-dd "); string death; if (uxDeathCheckBox.Checked) { death = dateTimePicker2.Value.Date.ToString("yyyy-MM-dd"); } else { death = "NULL"; } if (uxInsertButton.Text == "Insert") { try { var createdPerson = repo.CeatePerson(name, DOB, death); MessageBox.Show("The data has been successfully added."); } catch (Exception exception) { MessageBox.Show("Data failed to be inserted." + exception); } } else { var updatePerson = repo.UpdatePerson(PersonId, name, DOB, death); MessageBox.Show("The data has been successfully updated."); } //Show all people dataGridView1.DataSource = repo.RetrievePersons(); }