Thursday, 13 October 2011

How do you implement Paging in .Net?

The DataGrid provides the means to display a group of records from the
data source (for example, the first 10), and then navigate to the
"page" containing the next 10 records, and so on through the data.
Using Ado.Net we can explicit control over the number of records
returned from the data source, as well as how much data is to be cached
locally in the DataSet.
1.Using DataAdapter.fill method give the value of 'Maxrecords'
(Note: - Don't use it because query will return all records but fill
the dataset based on value of 'maxrecords' parameter).
2.For SQL server database, combines a WHERE clause and a ORDER BY
clause with TOP predicate.
3.If Data does not change often just cache records locally in DataSet
and just take some records from the DataSet to display.