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
- 5804 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 namespaces being used to access oracle database?
Explain how do you connect to sql server database without using sqlclient?
What is a dynaset in access?
Define data adapter?
Explain ODP.net
What is connection in ado.net?
What is sqldatareader?
Where is adodb dll located?
What are the different execute methods of Ado.Net?
What is different between sqlcommand object and command behavior object?
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?
How to bind the controls(best practice) comboboxes to the data in the dataset?
Is it possible to edit data in Repeater control?
What is Dataset Object?
What is ole word?
