private void comboBoxEtat_Validating(object sender, CancelEventArgs e) { if (cBEtat.Text != "") { int i = 0; bool b = false; while ((i < cBEtat.Items.Count) && (b == false)) { if (((structEtat)cBEtat.Items[i]).Etat.Equals(cBEtat.Text)) b = true; else i++; } if (b == false) { DialogResult a = MessageBox.Show("Voulez vous rajouter l'etat", "choix", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (a == DialogResult.Yes) { if (MaConnexion.ExecuteUpdate(connectionString, "insert into Etat (DesigEtat,rowguid) values ('" + cBEtat.Text + "',NEWID())") == 1) { DataSet dataset = MaConnexion.ExecuteSelect(connectionString,"select max(idEtat) from Etat"); structEtat strEt = new structEtat(dataset.Tables[0].Rows[0][0].ToString(),cBEtat.Text); cBEtat.Items.Add(strEt); cBEtat.SelectedItem = cBEtat.Items[cBEtat.Items.Count-1]; } } else cBEtat.Text = ""; } } }
private void chargerEtat() { //chargement des etats des biens String requete = "select * from etat"; DataSet dataSet = MaConnexion.ExecuteSelect(connectionString, requete); if (dataSet != null) { foreach (DataRow row in dataSet.Tables[0].Rows) { structEtat str = new structEtat(row[0].ToString(), row[1].ToString()); cBEtat.Items.Add(str); } } }