Difference between datareader and dataset?

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / swapna

26 Answers
59963 Views
Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Difference between datareader and dataset?..

Answer / sudheendra

DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to
DataSet(Fetches all the rows at a time). DataReader is
readonly so we cannot do any transaction on them. DataReader
will be the best choice where we need to show the data to
the user which requires no transaction ie reports. Due to
DataReader is forward only we cannot fetch the data
randomly. .NET Dataproviders optimizes the datareaders to
handle the huge amount of data.

DataSet
DataSet is always a bulky object that requires lot of memory
space compare to DataReader. We can say the dataset as a
small database coz it stores the schema and data in the
application memory area. DataSet fetches all data from the
datasource at a time to its memory area. So we can traverse
through the object to get required data like qureying database.

The dataset maintains the relationships among the datatables
inside
it. We can manipulate the realational data as XML using
dataset.We can do transactions (insert/update/delete) on
them and finally the modifications can be updated to the
actual database. This provides impressive flexibility to the
application but with the cost of memory space. DataSet
maintains the original data and the modified data seperately
which requires more memory space. If the amount of data in
the dataset is huge
then it will reduce the applications performance dramatically.

The following points will improve the performane of a dataset...

1. Don't use the commandbuilder to generate the sql statements.
Though it reduces the development time the query generated

by the command builder will not be always as required. For
example
To update the details of an author table the command

Is This Answer Correct ?

3 Yes

3 No

Difference between datareader and dataset?..

Answer / harshan kadam

Data reader is the forward and read only .it is a
disconnected architecture of the data base.it is the works
on retrive the data on the data base.

DataSet is the disconnected architecture.it is a works on a
data base is x-copy and retrive the data.it is a collection
of data collection(data row and data column) and is the
connection of the XML.

Is This Answer Correct ?

1 Yes

1 No

Difference between datareader and dataset?..

Answer / yasir a. mughal

 DataReader (Connection Oriented) is a forward only and
read only data while DataSet (Disconnected) is used to
maintain relationships between multiple tables.
 You can access one table at a time while it is define with
multiple tables.
 DataReader can't persists the data while DataSet can
persist the data
 DataReader operation is faster than DataSet operation.
 DataReader is connection oriented you can find the changes
in the database reflected in data reader immediately, where
as DataSet is pure disconnected one you will find the
changes only when you refresh the dataset using DataAdapter.

but conclusion....

Another often cited issue knows when to use DataReader as
opposed to DataSet objects. As a rule, if you don't need the
data once it has been read then uses a DataReader. The
DataReader offers a forward-only trip through data, whereas
DataSet allows you access to a group of data that may be
necessary to populate an ASP.NET Repeater or similar control.