Answer Posted / sharat
DataAdapter is a part of the ADO.NET Data Provider.
DataAdapter provides the communication between the Dataset
and the Datasource. We can use the DataAdapter in
combination with the DataSet Object. That is these two
objects combine to enable both data access and data
manipulation capabilities.
dataadapter
The DataAdapter can perform Select , Insert , Update and
Delete SQL operations in the Data Source. The Insert ,
Update and Delete SQL operations , we are using the
continuation of the Select command perform by the
DataAdapter. That is the DataAdapter uses the Select
statements to fill a DataSet and use the other three SQL
commands (Insert, Update, delete) to transmit changes back
to the Database. From the following links describe how to
use SqlDataAdapter and OleDbDataAdapter in detail.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is linq and entity framework?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is the use of Dataview?
What is command class in ado.net?
How will you fill the gridview by using datatable object at runtime?
What are the differences between OLEDB and SQLClient Providers?
Which is better ole db or odbc?
Explain ODP.net
What is the hierarchy of data in databases?
What is the difference between data reader and data adapter?
What is difference between ado and other data object?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is a serialized object?
What are the main differences between classic ado and ado.net?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
