Database-related

• MORE DETAILS
• VISIT PUBLISHER SITE

This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials together allow you to build a simple Guestbook for your web site.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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

• MORE DETAILS
• VISIT PUBLISHER SITE

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!

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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

• MORE DETAILS
• VISIT PUBLISHER SITE

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

• MORE DETAILS
• VISIT PUBLISHER SITE

You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem.... (show more)