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
- 5917 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 is the use of SqlCommand object?
What is data view and variable view?
What is dataset and datatable in ado.net?
What is ole in vb?
How to add an aggregate column?
Do you use stored procedure in ado.net?
What are all the different methods under sqlcommand?
What is the role of clr?
What is the advantage of ado.net?
What is ado.net components?
Why do we serialize data?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is row state?
Which method is used by command class to execute SQL statements that return single value?
What is ole db and odbc?
