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
- 13190 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
DataReader is better Choice for this type of Task becoz
DataReader is Read only, forward only access to data in
Connected Environment.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are different layers of ADO.Net?
Which property is used to check whether a DataReader is closed or opened?
What is openrowset?
Why do we need ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
how Sequence to connect and retrieve data from database using dataset?
Which object holds only data and does not interact with data source?
What is sqldatareader in ado.net?
What is ado.net object model?
Compare Data Reader & Dataset in ado.net?
What is isolation?
What are the connected and disconnected modes in ado.net?
Describe the disconnected architecture of ADO.NET’s data access model.
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is ado control?
