Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?

Question Posted / darshan.naokhare

Answers were Sorted based on User's Feedback



once data is fetched into dataset connection gets closed. but in datareader connection is always m..

Answer / hhh

DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster

Is This Answer Correct ?    9 Yes 0 No

once data is fetched into dataset connection gets closed. but in datareader connection is always m..

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

More ADO.NET Interview Questions

What are the benefits of using ado.net?

0 Answers  

What are different layers of ADO.Net?

0 Answers  

Can we bind one datareader wid two dropdown list?

5 Answers  

can we have multiple datatables in a datareader ?

18 Answers   Fulcrum Logic, Infosys, Kale Consultants, Ness Technologies,

what is trigger?

8 Answers   Microsoft, Precept Technology,

Explain the difference between ado and ado.net?

0 Answers  

How to find the count of records in a dataset?

6 Answers  

Which is faster ado.net or linq?

0 Answers  

How do I delete a row from a DataTable?

0 Answers   UGC Corporation,

what are types of Dataset ?

6 Answers   HCL,

What is the difference between data grid and data repeater?

0 Answers  

What is full form of ado?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories