Sql combo box values

See more:

C#

SQL

combobox

Hi.

What I need is a combo box to show all the values of a column from my SQL database. This part is working. What i need is the selected value not to be the name but the ID of the item.

string conString = @"CONNECTION STRING HERE; Password = PWD";
            SqlConnection conn = new SqlConnection(conString);
            DataSet ds = new DataSet();
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("select * from Devices", conn);
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                da.Fill(ds);
                
                comboBox1.DisplayMember = "Address";
                comboBox1.ValueMember = "ID";
                comboBox1.DataSource = ds.Tables[0];
                label7.Text = comboBox1.ValueMember;
            }
            catch (Exception ex)
            {
                //Exception Message
            }
        }

The address are shown in the combo, but it appears the value is still the text rather then the ID.

What have i done wrong?

What I have tried:

comboBox1.DisplayMember = "Address";
                comboBox1.ValueMember = "ID";