How do I access another column of data in a ComboBox?
Posted on 2009-12-24
Merry Christmas, experts. I hope someone is out there.
Here's my situation:
I have a Codes table with two fields, "Code" and "Description". I have successfully added the codes to the ComboBox, cboDocType, and want to access the "Description" column when the user selects a code in the combobox. The "Description" needs to go into a label control, "labCode", so that the user will know that they selected the correct code. What code do I need to accomplish this? Here's my code so far:
Dim dsCodes As New DataSet
Dim codesAdapter As New SqlDataAdapter("SELECT * FROM Codes ORDER BY Code", myConnection)
cboDocType.DataSource = dsCodes.Tables("Codes")
cboDocType.DisplayMember = "Code"
cboDocType.ValueMember = "Code"
labCode.Text = "I want to display the Codes.Description here."