Visual Basic 6.0 How to see entire data database

Asked By anonymous 7060 points N/A Posted on - 03/17/2012

I have a small access database and all I need to do is to show all the data in the database in mu form as a list/table of data. Please Help

• Status: Open
• Question Views: 908
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Kanhai Else 0 points N/A #82733

Visual Basic 6.0 How to see entire data database

 

All you need is to Open Projects->Components

Check Microsoft ADO data control

Check Microsoft Data Grid Control in the components Window.

Click OK.

See the tool bar with two small Icons.

Drag both Icons on your form.

On ADODC control, right click to Properties.

In properties click Build. Select the database driver you need. If oracle click(OLEDB provider for oracle).

Click Next. Enter Server name, user name, password,. Then Test Connection. If succeeded msg appears, then OK. Again OK. Goto Record Source tab at ADODC properties. Select Table at first combo box. Wait A while and you see list of all the tables under. Now select your table of choice. Click OK.

Now at properties of Datagrid control, at “datasource” assign ADODC1 (this is automatically displayed.)

 Run the form and you see the table in the grid.

Thanks.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: Visual basic