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
Explain about consistent programming model in the .NET framework?
Which namespace is used by ado.net?
IN an ASP.NET Web application if there is any error, how can you debug?
Describe a bubbled event and how it is used ?
Give an example of what might be best suited to place in the application_start and session_start subroutines?
How do you implement postback with a text box?
What is a 404 redirect?
What is the use of service provider?
Define viewstate in .net?
What is the exact purpose of http handlers?
benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks
9. Why should we hire you over the others waiting to be interviewed?
What is the usie of activex control in .net?
Can anyone please tell me that the question posted on this website are Sufficient for the interview with 2+ year experience in .net
Explain what does wsdl stand for?