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

This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.

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.

Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you.

This code demonstrates how to use an MD5 hash to encrypt user passwords when storing them in a database. There are constantly news items about companies where user information is compromised. By storing passwords using an MD5 hash, even if your database is compromised the passwords cannot be decoded. The only downside is that users cannot retrieve lost passwords, they must reset them.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.

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.

Compact and repair your access database online from ASP code. This is example code of how this can be done.

This sample ASP Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.

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.

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 tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.

This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

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.

This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements

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

Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available.

This database class handles Select, Insert, Update, and Delete. It also takes steps to ensure your SQL syntax is valid, and that memory leaks / errors are prevented. Tutorial comes with demo, downloadable code, and an in depth explanation.