Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.

This article wraps up the details of the real time data grid that started in part one of this two-part article. It looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page.

The author writes "CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.

This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers.

This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets.

The author writes "Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header on each page. This solution solves the problem." Source code available for download.

In this first article of the ASPHoleTools series, you will be shown the basics for data access. Covers how to create the basic include file for database access, and testing that data access was installed properly on your machine.