Latest web development tutorials

×

ASP Tutorial

ASP HOME ASP Introduction ASP Install ASP Syntax ASP Variables ASP Procedures ASP Forms ASP Cookies ASP Session ASP Application ASP #include ASP Global.asa ASP Send e-mail

VBScript Tutorial

VB HOME VB Variables VB Procedures VB Conditional VB Looping VB Examples VB Functions VB Keywords

ASP Objects

ASP Response ASP Request ASP Application ASP Session ASP Server ASP Error ASP FileSystem ASP TextStream ASP Drive ASP File ASP Folder ASP Dictionary ASP AdRotator ASP BrowserCap ASP Content Linking ASP Content Rotator ASP Quick Ref

ADO Tutorial

ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes

ASP and AJAX

AJAX Intro AJAX ASP AJAX Database

ASP Examples

ASP Examples ASP Quiz

ADO Introduction

❮ Previous Next Chapter ❯

ADO can be used to access databases from your web pages.

What you should already know

Before you continue you should have a basic understanding of the following:

HTML
ASP
SQL

If you want to study these subjects first, go to our Home page

What is ADO?

ADO is a Microsoft technology
ADO stands for ActiveX Data Objects
ADO is a Microsoft Active-X component
ADO is automatically installed with Microsoft IIS
ADO is a programming interface to access data in a database

Accessing a Database from an ASP Page

The common way to access a database from inside an ASP page is to:

Create an ADO connection to a database
Open the database connection
Create an ADO recordset
Open the recordset
Extract the data you need from the recordset
Close the recordset
Close the connection

❮ Previous Next Chapter ❯