Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gitam singh
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' 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a page life cycle? What are the events in a page life cycle?
What is the concept of view state in asp.net?
What is aspect-oriented programming?
What are the differences between clr & cts?
Will session work if cookies is disabled?
In a Repeater control how one can provide an alternating color scheme ?
In order to get assembly info which namespace we should import?
Which namespace is used by ado.net?
Differentiate strong typing and weak typing
Where is cookie used in asp.net?
Describe state management in asp.net?
what is the difference between response.write() and response.output.write()?
What are ASHX files?
How can exception be handled with out the use of try catch?
Please brief not about xsd,xslt & xml?
