Difference between DataSet and DataReader objects :-
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:
Post a Comment