To be able to read database data, the data must first be loaded into a recordset.
After an ADO Database Connection was 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:
We can also get access to the data in the "Customers" table using SQL:
After a recordset is opened, we can extract data from recordset.
The ADO Recordset object is used to hold a set of records from a database table.
View all methods and properties of the Recordset object.
Your Query was successfully sent!