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
- 5783 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Give few examples of datareader that is used in different dataproviders.
How to generate a single aggregate?
What does ole stand for in excel?
What are the important features of ado.net 2.0?
Does entity framework use ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
describe the dataset object in ado.net.
Give an example of a .net application which connects to microsoft access database using ado.net classes.
How do you update database through dataset?
What are the different ado.net namespaces?
What is the difference between executequery and executenonquery?
How we can provide data to ado.net?
How to add a check box or a dropdown list to a column in a datagrid?
How to pass multiple tables in datasets simultaneously?
How can I retrieve two tables of data at a time by using data reader?
