we have to use datareader. because it is more faster & efficient than

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?

Question Posted / anna

7 Answers
13110 Views
I also Faced
E-Mail Answers

Answer Posted / anna

we have to use datareader.
because it is more faster & efficient than dataset.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the advantage of ado.net?

1003

Which is the feature of ado.net?

999

What are the ado.net components?

1008

What does datareader object do?

983

how can implement dropdownlist in particular of dataset when try to update?

2766

What are the drawbacks of using ado.net?

957

What connected data?

937

Explain the different row versions available in table?

1039

What are the Features of a dataset

1279

What are ado.net objects?

1089

How to creating a SqlCommand Object?

1119

Which is the best method to get two values from the database?

953

Define data access layer?

932

How to maintain the relation between two tables in ADO.NET?

995

What are the different row versions available in table?

953