Database Tools

Have you ever wanted to use one of those badges, with a different color or size, with any text instead of just numbers, and with more than one line? If so, ALBadgeView is for you! This component allows you to do all the things mentioned...

Advertisements:

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.

AspGrid is an ASP based database tool which can be integrated in the users website. This tool gives full control over the database in the ASP applications in three lines of codes. This has several features like providing object interface for...

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.

This is a nice simple tutorial on how to manipluate a MS Access database using ASP. It will teach you how to add, remove and modify data from an Access database as well as connecting and disconnecting to the database in ASP.

Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update), other ISAM formats + FOXPRO option, real sample code, create a new DBF file.

This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.

MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.

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.

The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.

Add, edit, delete and query tables, fields and records remotely with this simple but powerful tool. Manage all your databases without any third party components.

Complete web database administration and code wizard in an easy to use Explorer interface. Browse, search, edit and design your data and create customizable ASP data pages in one click.

Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script.

A WSC DataGrid Class with examples you can just unzip and run. Does not need to be registered (but can be). Can be called from VBScript or JScript. See examples and readme for usage.

The New MDB component generates a dynamic Access database from an ASP recordset object. It also features: Set maximum set of records, and Other MDB functionalities.

This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.

Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient...

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

This application demonstrates how to create a page-through result set on a web page using frames. The records are displayed in the main frame and the status (current page, total pages) are displayed in the bottom frame. The application uses ASP,...

Database Add is a multi-platform compatible set of 3 database samples. The series will cover, inserting, deleting, and updating a table in a database. Being the first of the three, this one is commented the most heavily and should be read before...

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...

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.

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.

Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US...

Sorted Directory List is a multi-platform compatible script that sorts the results by some other file attribute. Check out our implementation of this highly-requested script. ASP 101 is the place developers go for Active Server Pages and ASP.NET...

This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.

It is very common operation to request one field of information via a database query. This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an...

DMXReady Members Area Manager allows you to quickly create a whole area of your website that is 'members only' so you can control who sees your content!

Database Delete is a multi-platform compatible script that is the number two in our set of 3 database editing samples. If you have any questions about this sample, please check out the first in the series as it is the most heavily commented. Both...

Paged Database Search is a multi-platform compatible database paging and a database search script all in one. ASP 101 is the place developers go for Active Server Pages and ASP.NET information!