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)

Answer / ganesh

DA is a collections of commands which will act like an
interface between dataset and database.

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.

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.

Answer / chandu babu

Data Adapter is a Mediater between dataset and database,

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.

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

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.

Answer / jeet

A Data Adapter functions as a bridge between a data source,
and a disconnected data class.

Answer / siva

Data adapter is a collections of commands which will act
like an interface between dataset and database

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

0 Answers  

What is the use of connection object in ado.net?

0 Answers   TryTechnicals Pvt Ltd,

Explain the advantage of ADO.Net?

0 Answers  

What is the use of Dataview?

0 Answers  

Why edit is not possible in repeater?

0 Answers  

What are the benefits of ADO.NET?

0 Answers   B-Ways TecnoSoft,

What are two types of transaction supported by ado.net?

0 Answers  

What are the parameters that control most of connection pooling behaviors?

0 Answers  

Give few examples of datareader that is used in different dataproviders.

0 Answers  

How to find the given query is optimised one or not?

0 Answers  

How is entity framework different from ado.net?

0 Answers  

Give an example of a .net application which connects to microsoft access database using ado.net classes.

0 Answers