Do you know that? Companies of all sizes will hire twice as many online workes next

What is the difference between DataSet and DataReader?

The following are the main difference between DataSet and DataReader. 


- Consumer Object 
- Provides Disconnected mode 
- Forward and backward scanning of data 
- Slower access to data 
- Can store multiple table simultaneously 
- Read/Write access 


- Provider Object 
- Provides Connected mode 
- Forward-only cursor 
- Faster access to data 
- Supports a single table based on a single SQL query 
- Read Only access