This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.

This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results.

Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.

This 4-page tutorial shows all the basics of using Active Server Pages and VBScript to work with databases. It covers Connecting to the Database, Working With Recordsets, and more.

It is possible to store images in a database using a number of third party tools or a custom built component. Once you have the images stored in your database, however, displaying them requires the use of a simple ASP page. This tutorial explains how to retrieve images from a database table and use them in an HTML page.

This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.

This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code.

This is an article about displaying binary data (images) from an Access database. Online demo and sample code available for download.

In order to connect to an Acees database with ASP through ODBC using a DSN file, you'll need to have full access to the server to create the DSN file, something that can be difficult if your site is hosted somewhere. This lesson will teach you an alternative connecton method, a DSN-less connection. As tests has shown, an DSN-less connection to Access gives you better performance. You can have up to 20-30 simultaneous users on the db without problems.

This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.