What is the DataAdapter Object in ADO.NET?
A Data Adapter represents a set of data commands and a database connection to fill the dataset and update a SQL Server database.
A Data Adapter contains a set of data commands and a database connection to fill the dataset and update a SQL Server database. Data Adapters form the bridge between a data source and a dataset.
Data Adapters are designed depending on the specific data source. The following table shows the Data Adapter classes with their data source.
A Data Adapter represents a set of data commands and a database connection to fill the dataset and update a SQL Server database.
A Data Adapter contains a set of data commands and a database connection to fill the dataset and update a SQL Server database. Data Adapters form the bridge between a data source and a dataset.
Data Adapters are designed depending on the specific data source. The following table shows the Data Adapter classes with their data source.
| Provider-Specific Data Adapter classes | Data Source |
| SqlDataAdapter | SQL Server |
| OledbDataAdapter | OLE DB provider |
| OdbcDataAdapter | ODBC driver |
| OracleDataAdapter | Oracle |
A Data Adapter supports mainly the following two methods:
- Fill (): The Fill method populates a dataset or a data table object with data from the database. It retrieves rows from the data source using the SELECT statement specified by an associated select command property.
The Fill method leaves the connection in the same state as it encountered before populating the data. - Update (): The Update method commits the changes back to the database. It also analyzes the RowState of each record in the DataSet and calls the appropriate INSERT, UPDATE, and DELETE statements.
Example:
- SqlDataAdapter da=new SqlDataAdapter("Select * from
- Employee", con);
- da.Fill(ds,"Emp");
- bldr =new SqlCommandBuilder(da);
- dataGridView1.DataSource = ds.Tables["Emp"];
0 comments:
Post a Comment