what are the differences between dataset and datareader?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a control toolbox?

505


What two types of data providers does ADO.NET supply? What determines which one you should use?

539


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

501


What is different between sqlcommand object and command behavior object?

541


What does datareader object do?

541






How to generate a single aggregate?

542


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

1930


Give an example that shows how to execute a stored procedure in ado.net?

570


Explain the architecture of ado.net?

543


Explain which name space is used to get assembly details?

530


What is the difference between Data adaptor and Data set?

515


Which object of ado contains datarow datacolumn collection?

518


What is ole in excel?

522


What is sqldatasource?

523


What is ado and rdo?

502