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 data control techniques?

503


Explain the namespaces in which .net has the data functionality class.

528


What are the Features of a dataset

663


How to read data with the sqldatareader ?

529


What we do with the object of ado.net dataset after using it?

518






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?

1925


What is the difference between sqlcommand and sqldataadapter?

491


Why do we serialize data?

489


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

520


What is ole db query?

515


What is the difference between OLEDB Provider and SqlClient?

523


Define bubbled event?

506


What is fill method in ado.net?

536


What is the significance of CommandBehavior.CloseConnection ?

563


What are two types of transaction supported by ado.net?

526