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
- 12902 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
Explain what are acid properties?
What are two types of transaction supported by ado.net?
Which ado.net object is very fast in getting data from the database?
Explain how to pass multiple tables in datasets simultaneously?
What is meant by executenonquery?
How can I retrieve two tables of data at a time by using data reader?
Explain the advantages and disadvantages of using datalist?
What is the difference between data reader and data adapter?
What do you mean by ‘batch updates’?
What is datatable in ado.net?
What is the difference between SqlCommand and SqlCommandBuilder?
What is ado.net code?
What is untyped dataset?
What is difference between ado and other data object?
What is difference between datagridview and datagrid control in winforms?
