what are the differences between dataset and datareader?

Question Posted / swapna

4 Answers
6460 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

Which is faster sqldataadapter and sqldatareader?

0 Answers

What is method to get XML and schema from Dataset? getXML() and get Schema ()

0 Answers

What is the difference between OLEDB Provider and SqlClient?

0 Answers

Explain what is datagrid with an example?