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?
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 will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is an orm, and why would you use one instead of plain old ado.net?
What is the default provider in ado.net?
What are the different execute methods of Ado.Net?
What are the advantages and drawbacks of using ado.net?
What are all the commands used with Data Adapter?
Explain the dataadapter class in ado.net?
What is ado.net in vb net?
What are all the different methods under sqlcommand?
What does executequery return?
What are the benefits of using of ADO.NET in .NET 4.0?
What is csdl entity framework?
How can we load multiple tables in to dataset?
What is dao and ado?
What is difference between datatable and dataset?