Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 13107 Views
- I also Faced
- E-Mail Answers
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 is method to get XML and schema from Dataset? getXML() and get Schema ()
What is the difference between sqlcommand and sqldataadapter?
What does executereader return?
What are the data access namespaces in .NET?
Does ado.net use odbc?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is the difference between executenonquery () and executescalar ()?
Define atomicity?
What is connected architecture in ado.net?
What is ole in excel?
What are the advantages and drawbacks of using ado.net?
What is typed dataset ?
Can we load multiple tables in a dataset?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
What are datareaders?
