Database Connectivity

[This is preliminary documentation and subject to change.]

If you are creating a Web-based application, your application is probably going to have forms. And if it's going to have forms, nine times out of ten it will also require some kind of database. ActiveX™ Data Objects (ADO) provides you with a set of powerful tools for accessing and manipulating data sources.

The samples in this section illustrate the techniques required to use ADO effectively, and how you can best put its functionality to use in a Web-based application.

Choose an example from the list below:

Simple Query: Illustrates how ADO and ASP can work together to perform simple database queries.
Query to Fill HTML Table: Demonstrates how to use ADO to fill an HTML table using a database query.
Limit Query Results: Shows how a script, using ASP and ADO, can limit the number of rows returned in a recordset.
Scrollable Query: Demonstrates a multi-directional, scrollable query with ADO.
Add/Delete Records: Illustrates the techniques required to add and delete records from a data source using ASP and ADO.
Update Records: Shows how an application updates existing records using ADO.
Executing Stored Procedures: Illustrates how an ASP script can execute stored database procedures using ADO.
ADO BLOB: Demonstrates how to access and update binary data objects with ADO.

For more information on ADO, and Microsoft® data access tools in general, refer to the Microsoft Data Access documentation.