ASP — ADO

Connection Object

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=server;Initial Catalog=mydb;"

' Close connection
conn.Close
Set conn = Nothing
%>

Recordset Object

<%
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM users", conn, 1, 1

Do While Not rs.EOF
    Response.Write(rs.Fields("name").Value & "<br>")
    rs.MoveNext
Loop

rs.Close
Set rs = Nothing
%>

Command Object

<%
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "SELECT * FROM users WHERE age > ?"
cmd.Parameters.Append cmd.CreateParameter("age", 3, 1, , 18)

Set rs = cmd.Execute
%>

Recordset Methods

Method	Description
Open	Open recordset
Close	Close recordset
MoveNext	Next record
MovePrevious	Previous record
MoveFirst	First record
MoveLast	Last record

Mini Practice

1. Create connection
2. Open recordset
3. Use command object
4. Navigate records

Up Next

Continue with SQL — SQL operations in ASP.