OleDbConnection cnn = new OleDbConnection(ConnectionString); OleDbCommand cmd = new OleDbCommand("SELECT * FROM CD WHERE cd_NAME != NULL", cnn); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); try{ da.Fill(ds, "CD"); lbTest.DataSource = ds.Tables["CD"]; lbTest.DisplayMember = "cd_NAME"; } catch{}
OleDbConnection cnn = new OleDbConnection(ConnectionString); OleDbCommand cmd = new OleDbCommand("SELECT * FROM CD WHERE cd_NAME != NULL", cnn); OleDbDataReader dr; try{ cnn.Open(); dr = cmd.ExecuteReader (CommandBehavior.CloseConnection); while(dr.Read()){ lbTest.Items.Add(dr["cd_NAME"]); } } catch{} finally{ cnn.Close(); }
sqlConnection1.Open(); sqlDataAdapter1.Fill(dataSet11); listBox1.DisplayMember = "FirstName"; listBox1.DataSource = dataSet11.Employees; sqlConnection1.Close();
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionlistBox1.BeginUpdate(); DataRow[] dr = dataset.Tables[0].Select("ID=5", "nom asc"); listBox1.DataSource = dr; listBox1.DisplayMember = dataset.Tables[0].Columns["nom"].ToString(); listBox1.ValueMember = dataset.Tables[0].Columns["ID"].ToString(); listBox1.EndUpdate();