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 an orm, and why would you use one instead of plain old ado.net?
Explain what is datagrid with an example?
What is ado asp?
Which provider is used to connect ms access, oracle, etc…?
What are all components of ADO.Net data provider?
What is sqldatareader?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
How can we serialize the dataset object?
Explain the different row versions available in table?
What is DataReader Object?
What is the default Timeout for SqlCommand.CommandTimeout property?
How to check if a datareader is closed or opened? IsClosed()
How to find the given query is optimised one or not?
Difference between sqlcommand and sqlcommandbuilder?
Which architecture does Datasets follow?