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

Which is faster entity framework or ado.net?

701


What is full form of ado?

719


How to Read, Add, Update and Delete record in Entity Framework ?

787


What are the different ado.net namespaces?

829


What connected data?

693


What are all the different methods under sqlcommand?

711


Which object holds only data and does not interact with data source?

725


What are the Features and disadvantages of dataset

776


How can you add or remove rows from the datatable object of dataset?

789


What are the methods of XML dataset object?

803


What is the role of data provider in ado.net?

744


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

698


Which is the feature of ado.net?

743


What are the ado.net connection pooling parameters?

663


Explain sqlconnection object?

765