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 happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers  

types of Store procedure in Sqlserver2000?

4 Answers  

What providers do you use to connect to oracle database ?

4 Answers   Digital GlobalSoft,

Being fresher How would i answer to the question that what is your salary exception?

4 Answers  

Which object is used to add relationship between two Datatables?

0 Answers  

Define connection string?

0 Answers  

What are ado.net objects?

0 Answers  

How many types of data table are in SQL.NET

4 Answers   Chetu India, HCL, MAHINDRA,

What is a non query?

0 Answers  

what is execute scalar?

11 Answers   Atharva Infotech, Dohatec New Media, Make eIT, Protech,

What are the benefits of using ado.net?

0 Answers  

What is the difference between dataset and datatable?

0 Answers