private void Valider_Click(object sender, EventArgs e) { if (Mode == 1) { try { clscnx.connecter(); date(); clscnx.msql("Insert into Client(cin,Prenom,Nom,Ville,Codepostal,Adresse,Sexe,N_permis,reduction,DateFP,Tel,Pays_origine,Pays_actuelle) values('" + CIN.Text + "','" + Prenom.Text + "','" + Nom.Text + "','" + Ville.Text + "','" + Code_postal.Text + "','" + Adresse.Text + "','" + b + "','" + N_permis.Text + "','" + Réduction.Text + "', '" + DateFP.Value.ToString("yyyy-MM-dd") + "','" + Tel.Text + "','" + Po.GetItemText(Po.SelectedItem) + "','" + Pa.GetItemText(Pa.SelectedItem) + "')", "Client"); Afficher(); afficher2(); menugeneral(true); } catch (Exception E) { MessageBox.Show(E.Message); } } if (Mode == 2) { try { //date(); clscnx.connecter(); clscnx.msql(" Update Client set cin = '" + CIN.Text + "' ,Prenom = '" + Prenom.Text + "',Nom = '" + Nom.Text + "',Ville = '" + Ville.Text + "',Codepostal ='" + Code_postal.Text + "',Adresse = '" + Adresse.Text + "',Sexe = '" + b + "',N_permis =' " + N_permis.Text + "',reduction ='" + Réduction.Text + "',Tel = '" + Tel.Text + "',Pays_origine = '" + Po.GetItemText(Po.SelectedItem) + "',Pays_actuelle = '" + Pa.GetItemText(Pa.SelectedItem) + "' where idclt = " + Idclt.Text + " ", "Client"); afficher2(); Afficher(); menugeneral(true); groupBox1.Enabled = false; } catch (Exception E) { MessageBox.Show(E.Message); } } if (Mode == 3) { try { clscnx.connecter(); panelid.Visible = false; clscnx.msql("Delete from Client where idclt = " + Id.Text + " ", "Client"); Afficher(); afficher2(); menugeneral(true); groupBox1.Enabled = false; } catch (Exception E) { MessageBox.Show(E.Message); } } else { textBox1.Text = null; } }