Database-related

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.

This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure.

This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the code in an automated fashion for use in VBScript connecting to MS SQL Server 7.

AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function.

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 article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid understanding of both data shaping and custom Recordsets.

This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.

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 explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own instead of cutting and pasting them.

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 example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.

This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the connection, and Utilities for Creating Valid SQL Statements.

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.

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.

This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download.

This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.

This article shows how to publish and distribute Microsoft Access reports on the web using ASP.

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.

This is an overview of SYSTEM DSN's, DSN-LESS Connections, and any database permissions that may need to be set on the server. Helpful for people just learning ASP as well as people with some experience.

By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. This article explains how to create a Visual Basic ActiveX DLL that controls database functionality.