13 August 2012

DataSet Vs Datareader

Dataset Vs DataReader
DataSet object DataReader object
Read/Write access.Read-only access.
Supports multiple tables from different databases.Supports a single table based on a single SQL query of one database.
Disconnected mode.Connected mode.
Bind to multiple controls .Bind to a single control.
Forward and backward scanning of data .Forward-only scanning of data.
Slower access to data .Faster access to data.
Greater overhead to enable additional features.Lightweight object with very little overhead.
Supported by Visual Studio .NET tools.Must be manually coded.

No comments: