Top Rated Scripts | ASP | Tutorials & Tips | Database-related

This article will explain how to import the contents of a text file (.txt) to an Access Database when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects in this article!

How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list.

This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.

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 group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials together allow you to build a simple Guestbook for your web site.

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.

You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.

Learn how to create dynamically dependent dropdown lists with. There's an online demo and source code provided.

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.

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.

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 when dealing with very large sets of data.

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.

Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail. Downloadable source code available.

Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.

This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages.

This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on 'insert' SQL statement.

Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.

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.