what are the differences between dataset and datareader?

Answers were Sorted based on User's Feedback



what are the differences between dataset and datareader?..

Answer / hardik

dataset is a disconnected architecture while a datareader
is a connected architecture object.

data reader is a faster than a dataset

Is This Answer Correct ?    3 Yes 0 No

what are the differences between dataset and datareader?..

Answer / anu

DataSet : you can move forward\backward of the data.It can
be Edited.It acts as a database after the connection is
closed.

Reader : It Just moves forward only.And cannot edit it is
only for Read Only purpose.For this connection object will
be there till u read all the values.

Is This Answer Correct ?    2 Yes 0 No

what are the differences between dataset and datareader?..

Answer / ramireddy eevuri

--> Dataset is disconnected architecture while
DataReader is connected architecture.
-->datareader is read only i.e, forward only while dataset
maintain persistanse data.

Is This Answer Correct ?    1 Yes 0 No

what are the differences between dataset and datareader?..

Answer / vamseedhar

dataset support manpulation,datareader doesnot support
manpulation
datareader is abstract class
dataset is collection of table
datareader is readonly forwardonly record type

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

How to add Primary key in DataSet

6 Answers  


What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

0 Answers  


What are the different ado.net namespaces are available in .net?

0 Answers  


What is maximum pool size in ado.net connection string?

0 Answers  


How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?

2 Answers  






What is data view and variable view?

0 Answers  


What do you know about ADO.NET's objects and methods?

0 Answers   NA,


We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

6 Answers   Accenture, FastStream,


What is ole in excel?

0 Answers  


Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,


What is DataReader Object?

0 Answers  


IF we have lot of records in Database. How we can handle them?

5 Answers   Honeywell,


Categories