ADO Basics: Creating a basic ADO database application

By: Christopher Moeller

Abstract: How do I create a basic ADO database application?

Question:

How do I create a basic ADO database application?

Answer:

If you are interested in learning how to create a simple ADO database application, here are the basic steps:

    1.    Drop a DataSource, DBGrid, ADOConnection, and ADOTable on your form.
 
    2.    Set the DataSet property of the DataSource1 component to ADOTable1 (in the Object Inspector).
 
    3.    Now, set the Connection  property of the ADOTable1 component to ADOConnection1 (in the Object Inspector).
 
    4.    Set the Login Prompt property of the ADOConnection1 component to false.
 
    5.    Also, double-click on the ConnectionString property, select "Use Connection String," and click on Build...
 
    6.    Then, under the "Provider" tab, select "Microsoft OLE DB Provider for ODBC Drivers," under the "Connection" tab select the "Use data source name" drop-down button and choose DeluxeCD, and then click on OK (twice).
 
    7.    Set the Connected property of the ADOConnection component to true.
 
    8.    Set the DataSource property of the DBGrid1 component and choose DataSource1.
 
    9.    Now, select the TableName property of the ADOTable1 component and choose Tracks.
 
    10.  Finally, set the Active property of the ADOTable1 component to true.  After the Table is made Active, the BDGrid will become populated with data.


Server Response from: ETNASC03