Paging through Recordset and Database

virendra_007

Dear All, I am implementing pagin in my project where I am showing around 10 recordset per page. I want that whenever I click on next page it shouldn't call the database again and again. Data fetching should be done at once. Can anybody tell me how to do this so that I can increase the performance of my database. There are 20,000 records I am getting from this query. Thanks and Regards, Virendra

Abolfazl Sheikhloo

tou can fetch data from database and store it in xml file before using in gridview or any control, then work with xml file for paging and sorting or ...

We Can Do Anything, If We Want It

N a v a n e e t h

virendra_007 wrote:

am implementing pagin in my project where I am showing around 10 recordset per page

What control you are using to show the results ? Is it a datagrid/gridview ? Both supports paging. You can set allowpaging=true and set the pagesize. This method for paging implementation is very easy. But efficient way will be doing the manual paging. First you need to find the total page by **totalrecords/pagesizesize**. Then depending on the page number you need to fetch only 10 records(your page size) from the database for that page. So your page may look like this **www.yourdomain.com/yourpaging.aspx?page=1**.

My Website | Ask smart questions

N a v a n e e t h

Abolfazl Sheikhloo wrote:

tou can fetch data from database and store it in xml file before using in gridview

What is the benefit of doing like this ? Assume 100 user accessing the page same time , will you create 100 XML files ?

My Website | Ask smart questions

Abolfazl Sheikhloo

no no no. you can manage your xml file for all users. your xml is simulated from database table or view. for example your xml contains 20,000 record and you need to all records but the database view contains 2,000,000 record and you don't need to all records. working with 20,000 records is faster than working with 2,000,000 records We Can Do Anything, If We Want It

rashadaliarshad

http://www.yourdomain.com/yourpaging.aspx?page=1.[^] can u provide any examples for this method?

:- Rashid Ali -: