Answer Posted / sandeep singh shekhawat

Data Reader is forword only it read one by one row. when it reach end the table then need to another connection open for it. it object create by command object method execute reader.

Data set is used for disconnect approch.It can have more than one table.

Define executenonquery?

896

---

What is dao and ado?

915

---

Which is faster datareader or dataadapter?

973

---

Does entity framework use ado.net?

959

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

881

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2069

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2362

---

What are dataproviders?

945

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1047

---

What is ado rdo dao in visual basic?

1148

---

How to work with disconnected data - the dataset and sqldataadapter?

968

---

What is the difference between SqlCommand and SqlCommandBuilder?

1055

---

Explain the difference between an ado.net dataset and an ado recordset?

1048

---

Explain the difference in record set and dataset?

923

---

What are the usages of the command object in ado.net?

1012

---