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 / 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 is ado.net in vb net?
What is the difference between sqldatareader and sqldataadapter?
What does adodb stand for?
What is isolation?
Does executenonquery return a value?
Explain what are the steps to connect to a database?
What are the rules to implement connection pooling?
How does entity framework work?
Explain the difference between an ado.net dataset and an ado recordset?
What is ado.net code?
Which is better entity framework or ado.net?
How to pass values into a datatable?
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 ado.net and oledb?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?