Valuemember and DisplayMember Iin a combobox??? Pls help

Accepted answer

comboBox1.Items.Add("Choose NameN"); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from Niveli"; com = new OleDbCommand(str, con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds, "Niveli"); comboBox1.DataSource = ds.Tables["Niveli"]; comboBox1.ValueMember = "ID_niveli"; comboBox1.DisplayMember = "NameN"; con.Close();

Kreshnike Rahmani13y ago

This really helped me :)

Satyapriya Nayak13y ago

SqlCommand cmd = new SqlCommand("select * from Niveli", con); SqlDataReader dReader = cmd.ExecuteReader(); if (dReader.HasRows == true) { while (dReader.Read()) cmbNiveliRegj.Items.Add(dReader["NameN"].ToString()); } dReader.Close();