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 maximum pool size in ado.net connection string?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the differences between OLEDB and SQLClient Providers?
What do you know about ado.net's objects?
Explain the architecture of ado.net?
What does sqldatareader return?
What are the disadvantages of using datalist?
What we do with the object of ado.net dataset after using it?
Define atomicity?
What is the default provider in ado.net?
How do you merge 2 datasets into the third dataset in a simple manner?
What are the different execute methods of Ado.Net?
Which provider is used to connect ms access, oracle, etc…?
What is a data control clerk?
What is the difference between Dataset. clone and Dataset.copy?