Need help in gridview and table

Question

Hi all, Pls somebody give me the solutions. Suppose i have data in database table. I wanna display all the field with data in gridview. In database table i have 1000 rows of data. But in gridview in one page can hold only 50 rows. So when i click on page 2 in gridview it should display next 50 rows....then again if click on page 3, gridview should display next 50 rows...like this it will continue. I don't want all the rows(1000 rows) to be loaded at a time. It should load dynamically everytime 50 rows only.. Pls give me the solution, how do i achieve it with code..

Thanks, Developer

Answer 1

See the link below

1- http://asimsajjad.blogspot.com/2009/08/custom-pager-for-gridview-control.html 2- http://asimsajjad.blogspot.com/2009/05/gridview-paging-and-sorting.html

and the link below for the database end paging http://asimsajjad.blogspot.com/2009/07/paging-in-sql-server-2000-store.html

Hope that will help.