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 are the Data providers in ADO.Net?

1013

---

What is ado control?

947

---

Can we connect two dataadapters to same data source using single connection at same time?

976

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2137

---

What are the core objects of ADO.NET?

1044

---

What are the classes in System.Data.Common Namespace?

1144

---

What are the different ado.net namespaces are available in .net?

1007

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

912

---

How can we perform transactions in .net?

1057

---

how can implement dropdownlist in particular of dataset when try to update?

2775

---

How do you connect to sql server database without using sqlclient?

1104

---

What is the difference between statement and preparedstatement interface?

993

---

What is ado code?

945

---

What are the various methods provided by the DataSet object to generate XML?

999

---

What are ado.net objects?

1105

---