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
ComboBox1.ValueMember = "ID"
ComboBox1.DisplayMember = "unit"
ComboBox1.DataSource = ds.Tables(0)
Catch ex As Exception