Database-related

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 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....
(show more)
(show less)

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.

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

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

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.

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

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.

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....
(show more)
(show less)

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.

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

This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.

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!

Basically, I had the problem of needing a marquee to scroll important updates but everyone who needed to update it was not HTML savvy. So I made it form based. And the coolest part about it is, you can control the background color, and the text color. That is good when you want different color combinations to have communicate different things. Like, black background and red text could mean urgent and blue background* and yellow text could be Happy Birthday! ...
(show more)
(show less)

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.

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.

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....:) ...
(show more)
(show less)

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....
(show more)
(show less)

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.