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 |
This Blog is about some useful link and some interview question in.Net. I am trying to give some useful information to you .