ADO Recordset

From http://www.w3schools.com (Copyright Refsnes Data)

# ADO Recordset

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

## Create an ADO Table 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:

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/northwind.mdb"

    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "Customers", conn
    %>

## Create an ADO SQL Recordset

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

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/northwind.mdb"

    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "Select * from Customers", conn
    %>

## 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:

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/northwind.mdb"

    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "Select * from Customers", conn

    for each x in rs.fields
       response.write(x.name)
       response.write(" = ")
       response.write(x.value)
    next
    %>

## The ADO Recordset Object

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.

From http://www.w3schools.com (Copyright Refsnes Data)