what is data Adapter?
Answers were Sorted based on User's Feedback
Answer / dinesh shrimali
Data adapter is bridge between Connection and DataSet ,
Data adapter in passing the sql query and fill in dataset
Eg.
Dim sqlStr as string
Dim DA as SqlDataAdapter
Dim DS As New DataSet
Sqlstr=”SELECT * FROM emp”
DA=New SqlDataAdapter(sqlstr, “Connection name”)
DA.Fill(DS)
Is This Answer Correct ? | 74 Yes | 10 No |
Answer / ganesh
DA is a collections of commands which will act like an
interface between dataset and database.
Is This Answer Correct ? | 39 Yes | 7 No |
Answer / chandresh kumar chhatlani
Data Adapter flows between Database's Connection and the
DataSet , It Retrieves data from the Database and send to
DataSet for the user.
Is This Answer Correct ? | 33 Yes | 5 No |
Answer / asfaq
Data Adapter is responsible for filling the dataset.In
another way we can say it works as bridge between data
store and dataset.
Is This Answer Correct ? | 19 Yes | 3 No |
Answer / chandu babu
Data Adapter is a Mediater between dataset and database,
Is This Answer Correct ? | 22 Yes | 8 No |
Answer / 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 |
Answer / lalit pathak
DataAdapter is a bridge between connection & DataSet.
DataAdaper is passing the sql queries to the dataset from
Database.
DataAdapter is a madiator between connection and dataset.
Data adapter is a collections of commands which will act
like an interface between dataset and database
Is This Answer Correct ? | 16 Yes | 5 No |
Answer / eduardo belmonte
DataAdapter is an object belonging to a DataProvider whose
function is to use Connection and Command objects so as to
retrieve data from a Database into a Dataset.
Also DataAdapter acts the other way, updating, inserting or
deleting info in the database as per the info present in
the dataset and according with the sql commands.
Is This Answer Correct ? | 11 Yes | 7 No |
Answer / jeet
A Data Adapter functions as a bridge between a data source,
and a disconnected data class.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / siva
Data adapter is a collections of commands which will act
like an interface between dataset and database
Is This Answer Correct ? | 15 Yes | 13 No |
What is sequence of code in retrieving data from database ?
3 Answers Accenture, BirlaSoft,
What is the difference between Optimistic and Pessimistic locking?
Which namespaces are used for data access?
0 Answers SwanSoft Technologies,
How to create dynamic gridview?
What are the ADO.NET Controls?
What is difference between ado.net and asp net?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Why is ADO.NET serialization slower than ADO ?
Explain the difference in record set and dataset?
What is two way data binding android?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
Does ado.net use odbc?