SQL INSERT statement is not executing but I am not receiving an exception either : On my button click event I am just wanting to insert a row into a table. When i click the button i get no exception and i also don't get my messagebox to show either. I have the messagebox as a way to check to see if the query had been executed. When i step through it skips the MessageBox and doesn't throw an exception. 

    private void BtnSend_Click(object sender, EventArgs e)
        {
           
                string theDate = dateTimePicker1.Value.ToString("MM-dd-yyyy");
                
                var select = "INSERT INTO Trinity3(Date, Device_S_N, Student_Last_Name, Student_First_Name, Student_Number, School, Grade, Damage)" +
                    "VALUES (@Date, @Serial, @LastName, @FirstName, @StudentNum, @School, @Grade, @Damage)" +
                    "COMMIT";

                SqlConnection connection = new SqlConnection("Data Source=CPS1113020004; Initial Catalog=Coweta Public Schools; Integrated Security=True");               
                //Create a SqlCommand instance
                SqlCommand command = new SqlCommand(select, connection);

                //Add the parameter
                command.CommandType = CommandType.Text;
                command.CommandText = select;
                command.Parameters.AddWithValue("@Date", theDate);
                command.Parameters.AddWithValue("@Serial",txtSerial.Text);
                command.Parameters.AddWithValue("@LastName",txtLastName.Text);
                command.Parameters.AddWithValue("@FirstName",txtFirstName.Text);
                command.Parameters.AddWithValue("@StudentNum", txtStudentNum.Text);
                command.Parameters.AddWithValue("@School",txtSchool.Text);
                command.Parameters.AddWithValue("@Grade", txtGrade.Text);
                command.Parameters.AddWithValue("@Damage", txtDamage.Text);
                //Execute the query
                try
                {
                    connection.Open();
                    command.ExecuteNonQuery();
                    MessageBox.Show("Records Inserted Successfully");
                }
                catch
                {
                    //Handle exception, show message to user...
                }
                finally
                {
                    connection.Close();
                }
                 
            this.Visible = false;
            var searchForm = new SearchForm();
            searchForm.ShowDialog();
        }