C# Combobox - item list using ODBC database

Question

How can I in C# get item list in combobox using as datasource database table connected by ODBC?? It's Pervasive database.

Answer 1

You can use the two properties of the combobox:

• ValueMember.

• DisplayMember.

To bind the items of the combo box to the data returned by odbc. And set the DataSource of the combo box to the list of items returned by the ODBC:

 comboboxName.DataSource = dataSetComingFromODBC;
 comboboxName.ValueMember = "Id";
 comboboxName.DisplayMember = "Name";

For how to connect to pervasive database, there is an article in their documenation on how to do so

• Connecting to a Pervasive Database