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
How can I retrieve two tables of data at a time by using data reader?
What is the difference between connected and disconnected environment?
Why do we need ado.net?
What is data relation in ado.net?
What are the drawbacks of using ado.net?
What are the different methods by which we can populate a dataset?
What is microsoft ado.net?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is data relation?
What is execute reader in ado.net?
Which is better ole db or odbc?
how Sequence to connect and retrieve data from database using dataset?
How can we load multiple tables in to dataset?
What is the namespaces being used to access oracle database?
What is the provider being used to access oracle database?
