private void button2_Click(object sender, EventArgs e)
        {
            this.Hide();
            Edit_Remove_Coach editRemoveCoach = new Edit_Remove_Coach();

            editRemoveCoach.Show();
        }
        private void dataGridView1_DoubleClick(object sender, EventArgs e)
        {
            //displaying the selected student in a new form to edit/remove
            Edit_Remove_Coach editRemoveCoachF = new Edit_Remove_Coach();

            editRemoveCoachF.textBoxId.Text    = dataGridView1.CurrentRow.Cells[0].Value.ToString();
            editRemoveCoachF.textBoxFname.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
            editRemoveCoachF.textBoxLname.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();

            //gender
            if (dataGridView1.CurrentRow.Cells[3].Value.ToString() == "Female")
            {
                editRemoveCoachF.radioButtonFemale.Checked = true;
            }

            editRemoveCoachF.dateTimePicker1.Value = (DateTime)dataGridView1.CurrentRow.Cells[4].Value;
            editRemoveCoachF.textBoxAge.Text       = dataGridView1.CurrentRow.Cells[5].Value.ToString();
            editRemoveCoachF.textBoxAddress.Text   = dataGridView1.CurrentRow.Cells[6].Value.ToString();
            editRemoveCoachF.textBoxPhone.Text     = dataGridView1.CurrentRow.Cells[7].Value.ToString();
            editRemoveCoachF.textBoxEmail.Text     = dataGridView1.CurrentRow.Cells[8].Value.ToString();
            editRemoveCoachF.textBoxSwm.Text       = dataGridView1.CurrentRow.Cells[9].Value.ToString();
            editRemoveCoachF.Show();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            Edit_Remove_Coach editRemCoachF = new Edit_Remove_Coach();

            editRemCoachF.Show();
        }