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)

What is ole data type?

971

---

What are the differences between OLEDB and SQLClient Providers?

1243

---

Explain sqlconnection object?

1067

---

Which is faster sqldataadapter and sqldatareader?

980

---

How to perform sorting on a table in ADO.NET?

1080

---

What is DataReader Object?

1098

---

Can we load multiple tables in a dataset?

1189

---

What is an orm, and why would you use one instead of plain old ado.net?

1098

---

What are the types of databinding?

1033

---

What are the rules to implement connection pooling?

1120

---

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1031

---

What is ado.net and its features?

1030

---

How to check if the Dataset has records ?

1056

---

What is ado rdo dao in visual basic?

1207

---

What DataReader class do in ADO.NET ?

1167

---