what is data Adapter?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we serialize data?

493


How to store data in memory?

506


What are the classes in System.Data.Common Namespace?

698


What are three methods for displaying data in a syncfusion datagrid

612


What is ado oledb and odbc?

502






How to check if the Dataset has records ?

530


How can we check that some changes have been made to dataset since it was loaded?

514


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

512


How to retrieve the user id which is provided while windows authentication?

586


What is microsoft ole db provider for sql server?

475


What Is Difference Between Ado And Ado.net?

558


What is the difference between connected and disconnected environment?

491


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

570


Explain which name space is used to get assembly details?

522


What is bubbled event can you please explain?

525