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


Please Help Members By Posting Answers For Below Questions

What is partial class?

754


What is the provider being used to access oracle database?

764


How to identify the updated rows in a dataset?

737


What is two way data binding android?

748


How to add a check box or a dropdown list to a column in a datagrid?

766


Which is better ole db or odbc?

703


What you mean by filtering of data?

732


The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1820


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

790


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

752


What is the use of adodc?

751


What are the connected and disconnected modes in ado.net?

712


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

774


Explain the differences between oledb sql server, oledbdotnet provider?

780


What is serialization and de-serialization in .net?

725