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:
Post a Comment