This application introduces the basic capabilities of ActiveX Data Objects (ADO) and demonstrates the following features in the modules specified:
| Technology Used | Modules |
| The Connection Object: | |
| Making and opening a connection | getCategories.asp |
| Executing a command with the Connection object | setOrders.asp |
| Making and opening a connection that specifies an OLE DB Provider as the data source provider | Customize.asp |
| Making and opening a connection that specifies an OLE DB Provider and a Data Shaping Provider | Customize.asp |
| Making and opening the first of multiple connections | Status.asp |
| The Command Object: | |
| Specifying a query that is a stored procedure | Catalog.asp |
| Creating an active connection, and executing a command | validatePassword.asp |
| Clearing the Command object | setOrders.asp |
| Specifying a query for the first of multiple connections | Status.asp |
| Specifying a query that is a stored procedure for the second of multiple connections | Status.asp |
| The Parameter Object: | |
| Specifying the input parameters of a command | Catalog.asp |
| Specifying the output parameters of a command | validatePassword.asp |
| Assigning values to the input parameters of a command | Catalog.asp |
| Assigning values from the output parameters of a command | validatePassword.asp |
| Clearing the Parameter object | setOrders.asp |
| The Recordset Object: | |
| Creating a Recordset Object | Customize.asp |
| Executing a command with the Connection object that returns a Recordset | getCategories.asp |
| Opening a connection object and specifying a query that does Data Shaping and returns a hierarchical recordset | Customize.asp |
| Creating an active connection, and executing a command that returns a Recordset | Catalog.asp |
| The Field Object: | |
| Extracting data from a Recordset and assigning the data to variables | getCategories.asp |
| Navigating through a hierarchical recordset, and extracting data from the child recordset's fields to display it | Customize.asp |
| Extracting data from a Recordset, assigning the data to variables, and displaying the data | Catalog.asp |
| Misc: | |
| Adding a row to session variable arrays | addToShoppingCart.asp |
| Assigning the values of session variables to temporary variables | setOrders.asp |
| Contruct an SQL query to retrieve a hierarchical recordset using Shape commands | Customize.asp |
| Constructing an SQL query from session variables | setOrders.asp |