Data Provider provides objects through which functionalities like OPENING and closing connection, retrieving and updating data can be availed.It also provides access to data source like SQL SERVER, Access, and Oracle.

Some of the data provider objects are:

• Command object which is used to store procedures.
• Data Adapter which is a bridge between datastore and dataset.
• Datareader which reads data from data store in forward only mode.
• A dataset object is not in directly connected to any data store. It represents DISCONNECTED and CACHED data.

The dataset communicates with Data adapter that fills up the dataset. Dataset can have one or more Datatable and relations.

 Data Provider provides objects through which functionalities like opening and closing connection, retrieving and updating data can be availed.It also provides access to data source like SQL Server, Access, and Oracle.

Some of the data provider objects are:

The dataset communicates with Data adapter that fills up the dataset. Dataset can have one or more Datatable and relations.