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 dll handles the request of .aspx page?
What is a ashx file?
What are server objects?
What are the difference between overriding and overloading?
6. Tell us about a time when you failed to meet a deadline. What were the repercussions?
What is different authentication mechanisms used in ASP.NET?
What are the asp.net security controls?
How to send a DataReader as a parameter to a remote client ?
What is the significance of attaching a profile while creating a user?
Explain cookies with example.
What is enableviewstate?
What is the biggest disadvantage of “Other Return Types” in Web API?
Explain serialization and deserialization?
If 200 is for all successful operation then why do we have 201 response codes?
3. What goals do you have in your career?
