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.

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.

This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started.

Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available.

This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code available for download.

In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

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.

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.