ADO Recordset

Create An ADO Table Recordset

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

After an ADO Database Connection has been created, as demonstrated in the previous chapter, it is possible to create an ADO Recordset.  

Suppose we have a database named "Northwind", we can get access to the "Customers" table inside the database with the following lines:

Practice Excercise Practice now

Create An ADO SQL Recordset

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

Practice Excercise Practice now

Extract Data From The Recordset

After a recordset is opened, we can extract data from recordset.  

Suppose we have a database named "Northwind", we can get access to the "Customers" table inside the database with the following lines:

Practice Excercise Practice now

The ADO Recordset Object

The ADO Recordset object is used to hold a set of records from a database table. 

Practice Excercise Practice now