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)

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1572

---

Which is faster sqldataadapter and sqldatareader?

500

---

How to add a javaScript function in a datagrid?

571

---

Explain the difference between ado and ado.net?

507

---

Name which operations can you not perform on an ado.net dataset?

486

---

---

What is difference between executenonquery and executequery?

472

---

What is XML serialization

589

---

Explain the various objects in dataset.

528

---

Which method is used to sort the data in ADO.Net?

1507

---

What is difference between datatable and dataset?

526

---

What is the difference between a datareader and a dataset?

518

---

How do you update database through dataset?

541

---

What is ole db query?

526

---

Is it possible to edit data in Repeater control?

532

---

What is oledb connection?

509

---