custom ASP.NET Paging

[asadsiddiqui]

Hello friends, how ru all, i'm working on a web site where paging is required i done ASP.NET DataGrid Paging but there are too many data records in my database so i want to use custom paging but i can't understand how can i do it so pls if anyone done custom paging pls tell me how it could be done.
Thanks
Bye

[dj4uk]

There are shed-loads of articles if you search on Google e.g. http://www.dotnetjunkies.com/Tutoria...B871F967F.dcik

The basic idea is that Basic Paging in ASP.NET returns all records from the datasource and then only displays the ones you want. Obviously if you have a large amount of data coming from the database it isn't very efficient. So custom paging allows you to only return the records required from the datasource. Generally this means you need to change you Data Access Layer to only return a "Page" rather than everything.

Give a shout if you have any problems.

DJ