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
Which is the best method to get two values from the database?
What is Data view?
What are the main differences between classic ado and ado.net?
What is disconnected scenario in entity framework?
Define different execute methods of ADO.NET command object ?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
What two types of data providers does ADO.NET supply? What determines which one you should use?
Explian About DataAdapters
What are all the classes that are available in System.Data Namespace?
What is the use of connection object in ado.net?
What is ado object model?
What are the data providers used in ado.net
How is it possible to get 2 tables of data at a time by using data reader?
What Is Difference Between Ado And Ado.net?
What is the difference between the clone() and copy() methods of the dataset class?