Home
Submit
Source
Feeds

Home » ASP » Database Integration ::

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.
Related Tutorials
ASP Database Integration
Counting Records In A Database Table
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Counting Records In A Database Table
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Using GetRows To Get All Records From Table
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: authors.aspalliance.com Report - View Tutorial

ASP Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Deleting Records Using Stored procedure
ASP / Database Integration
We will continue working on our sample table. Now we will delete some records using stored procuder. To work on the code create a sample database and run this sql script.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL INSERT statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL INSERT statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: www.stardeveloper.com Report - View Tutorial

ASP Database Integration
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.

Site: www.stardeveloper.com Report - View Tutorial

ASP Database Integration
How to Connect to Database using a Connection String
ASP / Database Integration
In this tutorial we will show you how to connect to our Access database called 'examples.mdb' and retrieve all the records from the table 'cars'.

Site: www.webcheatsheet.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL DELETE statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL UPDATE statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL DELETE statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: www.devhome.org Report - View Tutorial

 
Site Search

 
Categories
2D Graphics 3D Graphics Office Applications Databases Desktop Programming Web Development
 
Advertisement
 
Copyright © 2006-2008 TutCity.com | Submit Tutorials | Contact us | Terms of use | Privacy Policy