Interested to Buy Any Domain ? << Click Here >> for more details...
once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?
- 2 Answers
- 5895 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the advantages and disadvantages of using datalist?
What is difference between connected and disconnected architecture in ado.net?
Explain the various objects in dataset.
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is the difference between sqlcommand and sqldataadapter?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What are the major difference between classic ADO and ADO.NET?
What is a datareader object?
Explain how to find the given query is optimised one or not?
What is connection in ado.net?
how Sequence to connect and retrieve data from database using dataset?
What is aggregating data ?
What is the difference between executenonquery () and executescalar ()?
Which keyword is used to accept variable number of parameters?
What is the difference between linq and ado.net?
