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 the difference between sqldatareader and sqldataadapter?

915

---

What are ado.net objects?

1009

---

Explain the difference between sqlcommand object and command behavior object?

1007

---

Do you use stored procedure in ado.net?

991

---

What are all the classes that are available in System.Data Namespace?

960

---

What is data view and variable view?

855

---

What is ole in excel?

897

---

What does executequery return?

904

---

What is ado and rdo?

861

---

What is the difference between oledb sql server and oledbdotnet provider?

953

---

How would you connect to a database by using .NET?

890

---

Do we use stored procedure in ADO.Net?

940

---

Explain how to create dynamic gridview?

919

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

820

---

How do you implement locking concept for dataset?

939

---