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.
Paging Records using GetRows ASP / Database Integration
This article 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.
Limit query results with the Recordset object ASP / Database Integration
Here is an invaluable program that you can use to view and control the presentation of records in your database. We will use the Recordset object and the MaxRecords property via ADO, to set the number of records to return to the recordset and therefore to your screen. This is like a table in memory, holding records which are subdivided into individual fields.
Display Table on Web Page by Charles Carroll ASP / Database Integration
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.
Using Data Shape to create hierarchical recordsets ASP / Database Integration
In this code code snips; we will create hierarchical recordsets using data shaping. We will create a new table using two data table. We will list results of one table with sub-records related to master table. Data shaping is an advanced technic to spend less server memory.
How many records do I have in database table? ASP / Database Integration
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.
Updating Records Using Stored procedure ASP / Database Integration
This code source is focusing on creating a simple stored procudure updating records in a table. Code is simple and clear, you may modify this code to use in your applications. To work on the code create a sample database and run this sql script .
Display Top N records from MS Access ASP / Database Integration
This sample ASP code will give us a good idea how to display top 10 records, if we are using MS Access. Because MS Access database has got some limitations which we can not choose a limited data rows from complete database table. Of couse if you using SQL server, there is no any limitations.
ASP XML Admin Control ASP / XML and ASP
This is a small Web Application, this contains basic XML functions using ASP including a XML driven user authentication, adding new records, viewing records, editing and deleting records.
Fastest way of Database Access : Caching Records in Memory ASP / Database Integration
In this step by step tutorial I will guide you to build the fastest method to display records from the database using plain ASP. The technique we are going to use is based on a simple fact that you don't have to hit database every time you want to display records.
Generating random records from the Database ASP / Database Integration
In this article we will learn how to display random records from the database. From the articles so far, you will be able to display records from the database in a variety of ways and do a lot with them.