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)