Click here to Skip to main content
Click here to Skip to main content

Generic Paging for Recordset with Next Back Navigation

, 20 Jun 2005 CPOL
Rate this:
Please Sign up or sign in to vote.
This article is basically about a Paging control required for project purposes. One can use this just by changing three parameters.

Introduction

I had made implementing one of the paging functionalities an assignment during my free time. I have written this article so that one can draw some idea and make some control out of it. .NET has provided ready to go paging functionality for DataGrid, DataList etc. But when one has to create a dynamic table populated with thousands of records without using any ASP.NET control, then we have the write code manually.

Sample Image

Precondition

Connection string: change the connection string in Web.confiq file as per your configuration.

< add key="DSNConn" value="SERVER=localhost;DATABASE=Northwind;UID=sa;PWD=sa" />

Constant: There is one Constant.cs file. This Constant file is a storage area for constants and settings for pagination.

public class Constant
{
    public Constant()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public const int iShowNoPage = 5;//Show No Of pages....
    public static int jIter =iShowNoPage;
    public const int jVirtualInc = iShowNoPage;
    public const int iInitialRecDisplay = 10;
    // How many record you want to display per page..
}

Just make changes to two parameters, one is iShowNoPage = 5/per page (1, 2, 3, 4, 5) and the other is iInitialRecDisplay = 10. The iInitialRecDisplay parameter displays the number of records from the database on the screen.

Implementation

Note: the DropDownList contains three SQL queries which fetch records from three different tables. This is done to show that table 1 can contain 50 records, table 2 can contain 8 records and so on. In our case, total number of records may vary according to the table provided. On the basis of this total number of records, we have calculated the total number of pages mathematically (using Modulus fun). On doing so, one can get the number of pages per screen. For the rest of the logic one can refer the code as it is self explanatory.

Conclusion:

Please let me know if there are any bugs in my paging functionality. I would appreciate any suggestion on this front.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

santosh poojari
Technical Lead
India India
Whatsup-->Exploring--> MVC/HTML5/Javascript & Virtualization.......!
www.santoshpoojari.blogspot.com

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141220.1 | Last Updated 21 Jun 2005
Article Copyright 2005 by santosh poojari
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid