associated ID to appear in text box once name selected

Question

hey guys just wondering if anyone knows how to output the associated customer ID when i choose a name from a drop down list box this is my code to display the names in a drop down. just need to bind the textbox to the dropdownlist.

Carol Cashman · Answer

@kasun Lee unfortunatley i can not use a list box because values may change in the database and can not ne hardcoded.. do you know how to use a dropdownlist and textbox to do so?

Kasun Lee · Answer

This is how I would do it. Though this is a ListBox. private void listBox_emails_SelectedIndexChanged( object sender EventArgs e) { using (MySqlCommand cmd1 = new MySqlCommand( SELECT * FROM emailtable  conn)) { int cnt; string email; conn.Open(); reader = cmd1.ExecuteReader(); while (reader.Read()) { email = reader[ emails ].ToString(); //Display if the selected text maches the retrieved value in DB if (email == listBox_emails.SelectedItem.ToString()) { cnt = Convert.ToInt32(reader[ id ]); textBox_id.Text = cnt.ToString(); } } reader.Close(); conn.Close(); }