Database Connectivity

If you are creating a Web-based application, your application is probably going to have forms. And it will probably 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.

• Simple Query: Illustrates how you can use ADO and ASP together to perform simple database queries.
• Limit Query Results: Shows how your scripts, using ASP and ADO, can limit the number of rows returned in a recordset.
• Scrollable Query: Demonstrates a multidirectional, scrollable query with ADO.
• Add/Delete Records: Illustrates the techniques you need to use to add and delete records from a data source by using ASP and ADO.
• Update Records: Shows how your application can use ADO to update existing records.
• Executing Stored Procedures: Illustrates how your ASP scripts can use ADO to execute stored database procedures.

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