Answer Posted / ravinderreddy kothakapu

Dataset:
1)Dataset is a inmemory database for client application
process and it will contain more number of tables.
2)Dataset supports manipulations.
3)Dataset is a independent component in ADO.NET.
4)Dataset is a purly disconnected architecture with XML file
integration.XML file integration supports cross platform
independence.
5)Dataset supports bidirectional navigation.
6)Dataset defined multiple tables where contraints can be
applied.
7)Dataset can be persist the data.
Syntax: DataSet ds=new DataSet();

Data Reader:
1)Data Reader is a read only and forward only implimentation
2)Read only means it cannot support
manipulations(insert,delete, update)
3)Forward only means it support record pointer navigation in
forward direction means it is used for only once read
4) we can access only one table
5)Data reader cannot persist the data
6)It is a connected Architecture.
7)Most advantage is Data Reader is faster then Data Adapter.

Syntax:OleDb DataReader dr;
dr=cmd.ExcuteRader()

What is microsoft ado?

1007

---

Do you use stored procedure in ado.net?

1028

---

What is the use of adodc?

991

---

Define isolation?

969

---

What is the difference between statement and preparedstatement interface?

999

---

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

940

---

What are the different methods available under the sqlcommand class to access the data?

1047

---

What is ado circle?

1138

---

How to bind the controls(best practice) comboboxes to the data in the dataset?

1050

---

What is the difference between dataset and datatable?

1012

---

What is ado data control?

1001

---

What is the difference between executequery and executenonquery?

915

---

Explain what is datagrid with an example?

1098

---

What are the difference between readonly vs. Const?

1012

---

Is ado.net an orm?

964

---