How to show the whole access table in VB?
Can anyone help me about this? Thanks
Printable View
How to show the whole access table in VB?
Can anyone help me about this? Thanks
The quick and dirty way is:
- add ado data copntrol to your form
- right click on it and select properties
- select "use connection string" option and click "build" button
- select ms jet xx.xxx oledb provider and click "next" button
- click on the "..." button and navigate to your mdb file
- click "test connection" button
- if connection succeeded then click ok and select Recordsource tab on your ado data control properties pages
- set commandtype = 2
- select table name
- add Datagrid to your form and in the Properties window set datasource = your_data_control (you will be able to select it from the list)
You pretty much done - save and run your project.
For much more robust way check Database FAQ section.
There is a tutorial link in my signature, have a look!