Add to Favorites    Make Home Page 32848 Online  
 Language Categories  
 Our Services  

ASP » Tips and Tutorials » Database-related » Paging: Use ADO, getrows, or a Stored Procedure?


Search Projects & Source Codes:

Title Paging: Use ADO, getrows, or a Stored Procedure?
Platform n/a
Author Visit Author Website
Website Visit Website of - Paging: Use ADO, getrows, or a Stored Procedure?
Category ASP » Tips and Tutorials » Database-related
Hits 566
Description Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data.


Google Groups Subscribe to SourceCodesWorld - Techies Talk

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

Scripts Related to - Paging: Use ADO, getrows, or a Stored Procedure?

Script Name

Getting Your Quotes Right In SQL For ASP

It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.

Database Search Sample Code

Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.

ADO and Connectionless Recordsets

This is a detailed tutorial on Recordset object. It first briefly describes the ADO technology, then covers such topics as Connectionless Recordsets and How to display data with a Recordset with and without a connection object. This article is designed for VB as well as ASP programmers.

Display Image From Database

It is possible to store images in a database using a number of third party tools or a custom built component. Once you have the images stored in your database, however, displaying them requires the use of a simple ASP page. This tutorial explains how to retrieve images from a database table and use them in an HTML page.

Incorporating SQL Server 7.0/2000 Databases into your ASP Pages

This is a comprehensive tutorial on how to incorporate SQL server 7.0/2000 databases into your ASP pages. Topics include: Installation steps, Creating SQL Server 7.0/2000 Databases, Creating SQL Server 7.0/2000 Tables, Creating SQL Server 7.0/2000 Logins, Setting SQL Server 7.0/2000 Permissions, Increasing SQL Server 7.0/2000 Performance with Indexes, and Distributed SQL Server 7.0/2000 Transactions & Queries.

Running Stored Procedures in Access Database

Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.

Introduction & Data Access

In this first article of the ASPHoleTools series, you will be shown the basics for data access. Covers how to create the basic include file for database access, and testing that data access was installed properly on your machine.

Dynamically Generated HTML Forms

This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.

Named Recordsets

This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.

Search Database

This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.

Google Search


Source Codes is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019, All Rights Reserved.
Page URL:

Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review