Visual Basic 6.0 How to see entire data database

Asked By 7060 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #82733

Visual Basic 6.0 How to see entire data database

qa-featured

 

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.

Login/Register to Answer

Related Questions