How toshow name and insert values (name's ID ) from combobox

Jitendra Shekhawat

c# Windows Forms.

public void Load()

{

DataRow dr;

con.Open();

SqlCommand cmd = new SqlCommand("select * from city", con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sda.Fill(dt);

dr = dt.NewRow();

dr.ItemArray = new object[] { 0, "--Select City--" };

dt.Rows.InsertAt(dr, 0);

comboBoxunit.ValueMember = "city_ID";

comboBoxunit.DisplayMember = "city";

comboBoxunit.DataSource = dt;

con.Close();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Shekhawat9y ago
column names in city table is correct
Ranjeet Patra9y ago
Check the column names in city table whether it is spelled correctly or not
Jitendra Shekhawat9y ago
what is Error in My Code
Please Tell....
Abhilash J A9y ago
Try this,
hi,

http://stackoverflow.com/questions/9521980/combobox-valuemember-and-displaymember
cmd.CommandText = " Select * From GetUsersID";
        cmd.Connection = conn;
        conn.Open();
        DataTable dt  = new DataTable();

        dt.Load(cmd.ExecuteReader());
        conn.Close();

ComboBox1.ValueMember = "id";

ComboBox1.DisplayMember = "name";

ComboBox1.DataSource = dt;
Ranjeet Patra9y ago
Have a look at below links:

https://www.youtube.com/watch?v=sgMoNSNLLvg

https://www.youtube.com/watch?v=Tij1qYBllyA