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
- 13367 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
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?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is the difference between Command and CommandBuilder object?
What are the connected and disconnected modes in ado.net?
Explain why edit is not possible in repeater?
What is the hierarchy of data in databases?
Explain the advantage of ADO.Net?
What does ole stand for in excel?
Explain ado.net features?
What is the difference in record set and dataset?
What is ado.net and its features?
What is shadow copy?
Give few examples of datareader that is used in different dataproviders.
What is difference between connected and disconnected architecture in ado.net?
