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 / vijay

answer # 3 is really appreciate me thanks for giving
correct answer. i ve tested with sqldatasource with
gridview and change datasourcemode to datareader giving
error u must use dataset..

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which method is used to sort the data in ADO.Net?

1512


What are the Features of a dataset

666


Describe datareader object of ado.net with example.

511


How do you find the count of records in a dataset?

482


What are the usages of the command object in ado.net?

558






How do you update database through dataset?

544


What is the full form of ado.net?

510


How to load multiple tables into a dataset?

544


What are the parameters that control most of connection pooling behaviors?

517


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

557


how Sequence to connect and retrieve data from database using dataset?

757


What are the steps you will take to improve performance? Will you use dataset or datareader?

555


What is the difference between the clone() and copy() methods of the dataset class?

550


Why is ADO.NET serialization slower than ADO ?

569


What is the role of clr?

531