| Author: spider 11 Jun 2007 | Member Level: Gold | Rating:  Points: 2 |
dataset is disconnectede architecture data reader is live connection
when we access data from more than one table data set is more preperble and moving back is allowed . which are not in data reader
but one of draw back data set is low speed
|
| Author: Velmurugan Arjunan 02 Jul 2007 | Member Level: Bronze | Rating: Points: 2 |
DataSets are objects defined in the System.Data name space. These objects capture in memory the results of a query, Support backward and forward traversal through the data,enable data edting, and can propagate the edited changes back to the original data source.
Datareader are Read-Only,Forward-Only objects that iterate very quickly over the records in a table.
Data Reader are especially efficient for reading remotely records form far away DB.
|
| Author: pappan 29 Mar 2008 | Member Level: Gold | Rating: Points: 2 |
1. Dataset is defined as represent a menory representation of data from datatable;
2. DataManupulation is possible.
3. It contain multiple data table object, which refers to a rows and column object
DataReader:
1.Fetching the data in sequential Manner\
2.DataManipulation is not possible
3.Read a only one record at a single time
|