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

What is row state?

527


Is ado.net an orm?

518


What is the difference between ADO and ADO.Net?

593


What are the key features of ado.net?

667


How is entity framework different from ado.net?

488






How can we load multiple tables in to dataset?

571


What is data adapter in ado.net with example?

518


What does ole stand for in excel?

601


Describe briefly an ADO.NET Dataset ?

551


What are all the different methods under sqlcommand?

522


What are the differences between OLEDB and SQLClient Providers?

564


What is a data control clerk?

574


Explain how to find the given query is optimised one or not?

515


What is typed dataset ?

678


What is acid in ado.net?

533