ADO ADO Recordset (record set)

To read data from the database, then one of the data must first be loaded into a single record.

Create a table ADO record set (ADO Table Recordset)

After ADO database connection is created, as in the previous chapter, then we can build an ADO record set up.

Suppose we have a database called "Northwind", we can use the following code to access the database "Customers" table:

Create an ADO SQL recordset (ADO SQL Recordset)

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

Concentrated extract data from the records

After recording the set is turned on, we may extract data from the records.

Suppose we use a database called "Northwind", we can use the following code to access the database "Customers" table: