DataTable table = new DataTable(); table.Columns.Add("parametre",typeof(System.String)); this.cmbBox.DataSource = table; string requete = " select parametre from table_parametrage; SqlCommand maCommande = new SqlCommand(requete, maConnexion); SqlDataReader oReader = maCommande.ExecuteReader(); this.cmbBox.DisplayMember = "parametre"; table.Load(oReader); this.cmbBox.SelectedIndex = -1;
cmbBox.Items.Add(oReader["parametre"]);par
cmbBox.Items.Add(oReader.GetValue(0).ToString());
private void cmbBox_SelectedIndexChanged(object sender, EventArgs e) { maConnexion.Close(); maConnexion.Open(); string strRequete = "select parametre from table_parametrage"; SqlCommand maCommande = new SqlCommand(strRequete,maConnexion); SqlDataReader oReader = maCommande.ExecuteReader(); try { while (oReader.Read()) { cmbBox.Items.Add(oReader.GetValue(0).ToString()); } } finally { oReader.Close(); } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question