How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list.

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.

Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.

Learn how to search a database with keywords.

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.

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.

A discussion of how to use null values effectively in your database tables. Includes a discussion of the logic behind nulls and some practical programming techniques.

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.

Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.

This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.