once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?
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 is ole in excel?
What are the types of databinding?
What is ado.net full form?
What does datareader object do?
Which object holds only data and does not interact with data source?
What is dbcontext and dbset in entity framework?
Why is stored procedure used in ado.net?
how we can fire event in databound coulm in datagfrid withot using button?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
Difference between sqlcommand and sqlcommandbuilder?
What are the advantages and drawbacks of using ado.net?
How to add a check box or a dropdown list to a column in a datagrid?
How does ado.net work?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
Explian About DataAdapters