|
|
To be specific to the topic and give answer to
this question without arguing a lot, following are the differences between
DataSet and DataReader objects:
Datareader is connected architecture while
Dataset is a disconnected architecture. This means you need to keep the
connection open in DataReader to reader from it. Once the connection is closed
you cannot read data from DataReader object. On contrast DataSet object works
in a disconnected mode. You fill data into DataSet object and then close the
connection. After that you can use/read data from this DataSet object any time
you like, regardless of the state of current connection.
DataReader provides read-only (forward-only)
access to data. While the DataSet object can hold more than one data table from
the same data source. DataSet object can also contain relationships between
these data tables.
Dataset object can persist contents while
DataReader object cannot persist contents, they are forward only.
This Post is written By Mohammad Roman
0 comments:
Post a Comment