Thursday 9 August 2012

What is DataAdapter

DataAdapter

To retrieve data from the database and to fill a table in a DataSet we need DataAdapter. It's an ADO.Net Object and It is provider specific.

DataAdapter is like a bridge between a single DataTable in the DataSet and the DataSource. You can perform Fetch, Insert, Upadte, Delete operation using DataAdapter.

NameSpace to use DataAdapter

System.Data.SqlClient      /*For SqlServer*/
System.Data.OleDb          /*For OleDb Connection*/
System.Data.OracleClient   /*For Oracle*/

DataAdapter Architecture 

 

Example


  


No comments: