Selecting, deleting and inserting database records is part and parcel of dynamic web development...be it ASP, PHP, Python, whatever.....and of course, add to that list updating records.....But how to do it in Classic ASP?....well, I'm about to show you in 3 simple steps, so grab a can of Dr Pepper and pay attention, because you're about to get schooled....:)

This tutorial shows how to delete database records using just the Connection Object, without the need to create a Recordset Object. Moreover, it explains why using a Recordset is bad practice for queries such as INSERT, UPDATE and DELETE.

This ASP source code describes a short way to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database. Last part of code to select our record using our random number. We must move dynamic cursor in database table and move it to row number. There a few ways to move cursor to row, but personally we can do it similiar as paging records. We select all records from table dividing one record per page. Complete reference code is included.

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

An easy way to delete duplicate data from a database such as MYSQL or MSSQL.

This tutorials based on a bit of knowledge on SQL. Sample code displays us how to get and show name of columns with values.

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 tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements

Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.

Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.

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

In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.

Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.

Data repeaters in .NET are very useful to display database records onto screen. This tutorial shows you how easy nesting repeaters to save time. Features example code and full explaination.

This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.

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.

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.

Tutorial and ASP code to compact MS Access Database just 1 file.

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 ADO command object to perform faster singleton queries.