Data Provider consists of 1)Commands2)Connection3)DataAdapterCommand:The DBCommand object serves to encapsulate the SQL commands you willuse to interact with the database. Using the DBCommand class allows you toreuse commands, and to store them and otherwise treat them as objects withwhich you can interact.Connection:The DBConnection object encapsulates your connection to a particular database. .DataAdapter:The job of the DataAdapter, is to decouple the DataSetfrom the underlying database. It does this by providing a Fill() method, whichretrieves data from the database and fills tables in the dataset. To accomplishthis decoupling, the dataAdapter encapsulates the various SQL commandsused to manipulate the database (select, insert, delete, and update).These are the major components of the data provider in ado.net. Any doubts further you can give reply to this post or mail to ([email protected])