How listbox read data from Microsoft Access
- Thread starter h0T
- Start date
Paszt
Staff member
The standard listbox doesn't "read data from microsoft access". Here's a link to an MSDN article that shows how to create a databound listview control: Creating a Data Bound ListView Control
A listView is more appropriate for showing tables of data. The listbox would suffice if you only had one column of data to display.
A listView is more appropriate for showing tables of data. The listbox would suffice if you only had one column of data to display.
bloukewer
Well-known member
- Joined
- Jul 2, 2004
- Messages
- 88
- Programming Experience
- 3-5
1. Create a connection
2. Create a data-adapter
3. Create a dataset
4. Lets say the Dataset's name is 'DS1', it contains a table called 'tab1' and a column named 'col1' :
listbox.datasource = DS1
listbox.DisplayMember = "tab1.Col1"
To my knowledge, only ONE Column can be bound to a Listbox at a time. The procedure above also applies to Comboboxes, which is often more effective.
2. Create a data-adapter
3. Create a dataset
4. Lets say the Dataset's name is 'DS1', it contains a table called 'tab1' and a column named 'col1' :
listbox.datasource = DS1
listbox.DisplayMember = "tab1.Col1"
To my knowledge, only ONE Column can be bound to a Listbox at a time. The procedure above also applies to Comboboxes, which is often more effective.
