Setting Combo-box Value and Display Data with VB.Net

I was working on a Brokerage Calculation project where I need to load a table’s data into combo box as in the form of value member and display member because a combo-box store two value ID which not shown at drop down list but reside in combo-box .

We need to Set/Get data through value because it’s mostly primary key and  display mode for display 

field. Take a look on following code:

Dim con As New OleDbConnection(getconstr)

Dim da As New OleDbDataAdapter(sql, con)

Dim ds As New DataSet

 Try

da.Fill(ds)

ComboBox1.ValueMember = "ID"

            ComboBox1.DisplayMember = "unit"

            ComboBox1.DataSource = ds.Tables(0)       

Catch ex As Exception

            MsgBox ex.Message)

 End Try

Next Topic