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 / 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
What connected data?
How do you merge 2 datasets into the third dataset in a simple manner?
Explain the difference between sqlcommand object and command behavior object?
What is disconnected architecture in ado.net?
Explain the basic use of "dataview" and explain its methods.
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
Define partial class?
What is ole in vb?
What is disconnected scenario in entity framework?
What are advantages of microsoft-provided data provider classes in ado.net?
What are datareaders?
What are all the different methods under sqlcommand?
What are the different methods by which we can populate a dataset?
What is the difference between the clone() and copy() methods of the dataset class?
What is variable view?