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
Which object encapsulates state or data of a user?
What is a query string in a url?
What are the advantages and limitations of query string?
Explain about secure socket layer?
What is the difference between rest and restful?
What is the basic difference between asp and asp.net?
Fetch one page value to another page without using state-managment ?
When Cookies are expired in ASP.NET?
What is difference between asp.net and asp?
What is paging in context of Memory?
What are the ways to sending the data in ASP.NET page?
What is page fragment caching?
What is an example of an application service provider?
What is web api vs wcf?
Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default ?
