ADO TutorialLesson 63Free preview

ADO Recordset

This lesson is part of ASP · All levels

Summary

The recordset stores the query results in a row that can be scrolled one by one from start to finish. The current row position is accessed via rs("column"), then moved to MoveNext until reaching EOF. Understanding the concept of EOF and active rows is key to reading, modifying, and storing data correctly.

Key points

Recordset is made from conn.Execute or object Command.
The value column on the active row is taken with rs("nama") or rs.Fields("name").
MoveNext shifts to the next row until rs.EOF becomes true.
Rs.Close and Set rs = Nothing done after completion.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.