How to show the access table in VB

[karsen]

How to show the whole access table in VB?
Can anyone help me about this? Thanks

[RhinoBull]

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.

[dee-u]

There is a tutorial link in my signature, have a look!