what is data Adapter?

Answers were Sorted based on User's Feedback



what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

Answer / chandu babu

Data Adapter is a Mediater between dataset and database,

Is This Answer Correct ?    22 Yes 8 No

what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

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

what is data Adapter?..

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

Post New Answer

More ADO.NET Interview Questions

Which ado.net object is very fast in getting data from the database?

0 Answers  


What is an ADO.Net?

0 Answers  


What are the several execute methods of ado.net?

0 Answers  


About ADO and its objects ?

1 Answers   DELL,


Which name space is used to get assembly details?

0 Answers  






What are the rules to implement connection pooling?

0 Answers  


Is entity framework better than ado.net?

0 Answers  


Describe connection object in ado.net

0 Answers  


How will you fill the gridview by using datatable object at runtime?

0 Answers  


Does sqlclient and oledb class share the same functionality?

0 Answers  


If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,


What is executequery?

0 Answers  


Categories