Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 20000 records . In a page at each time
100 records to be displayed. What are the steps u will take
to improve performance? will you use dataset or datareader?
- 7 Answers
- 13192 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay
we have to use a dataset because on using datareader
forward only paging can be achieved. Suppose if you are at
1000 page and you want to go back to 999th page, if you use
datareader it cannot be achieved, since it does not support
backward navigation.
Dataset supports forward and backward navigation
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How can I retrieve two tables of data at a time by using data reader?
What is the use of ADO.NET and XML web services?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Some important instruction regarding ADO.NET connection string ?
What does sqldatareader return?
What are the different layers of ado.net?
What is maximum pool size in ado.net connection string?
What is the advantage of ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What are the uses of Stored Procedure?
What is acid in ado.net?
Which method is used by command class to execute SQL statements that return single value?
How to add a javaScript function in a datagrid?
How we can provide data to ado.net?
What is the difference in an abstract class and an interface?
