We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.
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 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 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.
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.
Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.