Easy Tutorial
Ado Ref Error Ado Sort Ado Ref Record Ado Display Ado Command Index Ado Ref Stream Ado Tutorial Ado Connect Ado Intro Ado Query Ado Examples Ado Summary Ado Datatypes Ado Ref Recordset Ado Ref Field Ado Getstring Ado Add Ado Recordset Ado Ref Connection Ado Ref Parameter Ado Ref Property Ado Delete Ado Update
❮ Ado Add Ado Ref Connection ❯

ADO Recordset

To read data from a database, the data must first be loaded into a recordset.

Creating an ADO Table Recordset

After creating an ADO database connection, as described in the previous chapter, you can then establish an ADO recordset.

Assuming we have a database named "Northwind", we can access the "Customers" table in the database using the following code:

Creating an ADO SQL Recordset

We can also use SQL to access data in the "Customers" table:

Extracting Data from a Recordset

Once the recordset is opened, we can extract data from it.

Assuming we have a database named "Northwind", we can access the "Customers" table in the database using the following code:

❮ Ado Add Ado Ref Connection ❯