what are the differences between dataset and datareader?

Question Posted / swapna

4 Answers
7800 Views
Choice Solutions, I also Faced
E-Mail Answers

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

What is the main difference between ADO and ADO.Net

4 Answers HCL,

Which is better entity framework or ado.net?

0 Answers

What are the ado.net connection pooling parameters?

0 Answers

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?