In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers.

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.

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server).

It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words.

This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.

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.

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.

When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object.