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
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'
parameter
(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.