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 are the benefits of ADO.NET?
What you mean by filtering of data?
What is ado.net object model?
Can you explain how to enable and disable connection pooling?
What is the maximum pool size in ado.net connection string?
How do you merge 2 datasets into the third dataset in a simple manner?
What is executequery?
Which is faster sqldataadapter and sqldatareader?
What are the steps to connect to a database?
What are the namespaces used in ado.net for data access?
What is difference between executenonquery and executequery?
What are the ado.net components?
What is ado.net components?
What is the difference between oledb sql server and oledbdotnet provider?
What is data access pattern?