Do you know that? 43.8% of freelancers get the bulk of their training by self taught 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