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

What is disconnected architecture in ado.net?

0 Answers  


What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

1 Answers   TCS,


What is the maximum pool size in ado.net connection string?

0 Answers  


About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

1 Answers   MMTS,


What is ado and dao?

0 Answers  






what is trigger?

8 Answers   Microsoft, Precept Technology,


What is azure ado?

1 Answers  


What is difference between dataset and datatable?

0 Answers  


Explain the difference between data reader and data set?

0 Answers  


how would i implement dropdownlist in gridview using c#

2 Answers  


How do you merge 2 datasets into the third dataset in a simple manner?

0 Answers  


Explain what a diffgram is and its usage ?

2 Answers  


Categories