Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed.

A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.

Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.

Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.

This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.

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.

It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.

You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.

This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.