private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         ProfDAO.Delete_client(int.Parse(txt_ID.Text));
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 private void Ajouter_Click(object sender, EventArgs e)
 {
     try
     {
         ProfDAO.Insert_client(tbnom.Text, tbprenom.Text, tbadresse.Text, tbmail.Text);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 private void modifier_Click(object sender, EventArgs e)
 {
     try
     {
         ProfDAO.Update_client(int.Parse(tbID_p.Text), tbnom.Text, tbprenom.Text, tbadresse.Text, tbmail.Text);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 private void button2_Click(object sender, EventArgs e)
 {
     try
     {
         List <Profs> ListClients = ProfDAO.Get_clients();
         grid_clients.DataSource = ListClients;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 private void button3_Click(object sender, EventArgs e)
 {
     try
     {
         Profs pro = ProfDAO.Get_client_ID(int.Parse(tbID_p.Text));
         tbnom.Text     = pro.Nom;
         tbprenom.Text  = pro.Prenom;
         tbadresse.Text = pro.adresse;
         tbmail.Text    = pro.mail;
         List <Profs> L = new List <Profs>();
         L.Add(pro);
         grid_clients.DataSource = L;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }