I have GridView that pulls a datasource that returns many a thousands of records. I am thinking of a scenario where I just pull the frist 1000 records and display them. And if user is interested to view the rest of the records then go to the database and display the other 1000 records and so on.
The things I need to figure out are below:
1).Is there way I can put a link that reads "Click here for newxt 1000 records" right next to the paging (pager at the bottom of the grid). If so then how do I go about it.
2).How do I get only the first set amount of records (say first 500 or 1000 ...) out of thousands of recrods from the datasource. Is there an in ADO.NET to use or can any body proivde some inputs?
We are using .NET 3.5 and SQLserver 2008.
Thanks in advance,
View Complete Post