ADO Data Control

               

The ADO Data Control is similar to the intrinsic Data control and the Remote Data Control (RDC). The ADO Data Control allows you to quickly create a connection to a database using Microsoft ActiveX Data Objects (ADO).

Remarks

At design time, you can create a connection by setting the ConnectionString property to a valid connection string, then set the RecordSource property to a statement appropriate to the database manager. You can also set the ConnectionString property to the name of a file that defines a connection; the file is generated by a Data Link dialog box, which appears when you click ConnectionString on the Properties window and then click either Build or Select.

Connect the ADO Data Control to a data-bound control such as the DataGrid, DataCombo, or DataList control by setting the DataSource property to the ADO Data Control.

At run time, you can dynamically set the ConnectionString and RecordSource properties to change the database. Alternatively, you can set the Recordset property directly to a  previously-opened recordset.