How To Connection ADO Components

After you install the ADO components, it's time to learn how to connect a database with these components. 

For that follow the steps below:

1. Select and click on the toolbox Adodc object, then draw the object on the form.
2. Select and right click Adodc object in the form, then the popup menu will appear. select it and click with the left mouse button ADODC Properties. Property pages dialog box will appear.
3. Click the Build button, the Data Link dialog box will be displayed properties. This dialog box contains a list of the connection provider. Select "Microsoft Jet 4.0 OLE DB Provider".
4. Then click the Next button or the Connection tab. In select or enter a database name: you just click the button (...), then point dialog box displayed select Access Database. In this box where you navigate a database stored position.
5. You can test whether the database is connected or not, that is by clicking the Test Connection button.
6. Then click Ok button, then click OK one more time. The next step is determine the use of Recordsource Database Nwind.mdb examples. Click Recordsource tab, select the Command Type 2-adCmdTable, and the Table or the stored procedure name select Customers, then click Ok.
7. Up here you have successfully created a database connection with controls Nwind ADO Objects.