Introduction to ADO

Course Recommendation:

ADO is used to access databases from web pages.

The basic knowledge you should have

  • Before proceeding with the study, you should have a basic understanding of the following knowledge:
  • Basic understanding of WWW, HTML, and website construction
  • ASP (Dynamic Server Page)

SQL (Structured Query Language) If you wish to learn these projects first, please visit our Home Page

Access these tutorials.

  • What is ADO?
  • ADO is a Microsoft technologyADO refers to ActiveX Data Objects (A ActiveXD DataO
  • ADO is a Microsoft ActiveX component
  • ADO is automatically installed with Microsoft's IIS
  • ADO is a programming interface for accessing data in a database

Accessing Database from ASP Page

The usual method to access a database from within an ASP page is:

  1. Create an ADO connection to the database
  2. Open Database Connection
  3. Create an ADO Recordset
  4. Extract the data you need from the recordset
  5. Close Recordset
  6. Close Connection