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
- 10295 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
Name which operations can you not perform on an ado.net dataset?
What is dao and ado?
What are basic methods of dataadapter?
Which object of ado contains datarow datacolumn collection?
How is entity framework different from ado.net?
Which method in OLEDBAdapter is used to populate dataset with records?
Does sqlclient and oledb class share the same functionality?
What is difference between datatable and dataset?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is ado.net code?
What is the difference between data grid and data repeater?
Why do we need ado.net?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is an orm, and why would you use one instead of plain old ado.net?
