Difference between datareader and dataset?
Answer Posted / ankur
data reader is connection oriented.it can access only one
value from the database.but the advantage is that it is
faster that dataset operation.
dataset is disconnected.using dataset you can access any
number of values. it can't be used without data adapter.
dataset can contain any number of tables and it maintain
the relationship between tables. when you refesh the
dataset then the changes affect the database
| Is This Answer Correct ? | 16 Yes | 16 No |
Post New Answer View All Answers
What is openrowset?
What is the full form of ado.net?
What are advantages of microsoft-provided data provider classes in ado.net?
Explain how can we load multiple tables in to dataset?
What is connection in ado.net?
What does ado stand for?
What is disconnected architecture in ado.net?
Explain how do you connect to sql server database without using sqlclient?
Can we do database operations without using any of the ado.net objects?
What is basic use of data view?
how can implement dropdownlist in particular of dataset when try to update?
Which namespaces are used for data access?
Which is better entity framework or ado.net?
What is ado.net full form?
What DataReader class do in ADO.NET ?