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
What two types of data providers does ADO.NET supply? What determines which one you should use?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the difference between Command and CommandBuilder object?
What are the key features of ado.net?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What does ado stand for?
What is difference between entity framework and ado.net?
What is data relation in ado.net?
Define different execute methods of ADO.NET command object ?
What are the usages of the command object in ado.net?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is data adapter in ado.net with example?
How do you update database through dataset?
What is difference between ado and other data object?
What is the difference between the clone() and copy() methods of the dataset class?