Answer / kavitha

in connection less architecture connection to the database
need not be persist till the end of the process.after
fetching the data form database it is pushed in database
object called dataset and connection object need not to be
persist and its closed. and the data will be available from
the dataset.


data reader - ADO.NET DataReader to retrieve a read-only,
forward-only stream of data from a database. Using the
DataReader can increase application performance and reduce
system overhead because only one row at a time is ever in
memory.Connection to the database is maintained till the
end.it is simply like an ado object.it contains only one
table at a time.it is much faster than dataset.


dataset - is used to hold the data from the database along
with their relation. it is connection less object.it also
persist the value which are retrieved form the database.
it is a bit bulky object.it gives both forward and backward
access to data. it uses XML.it can consist more than one
table.we have atrribtes for the dataset


dataset
datatable
datarow
datacolumn

an adapter object is used to fill the data from the database.

dataadapter - dataadapter is a database object which
used to fill the dataset object with data from the database.

Answer / prabhat saxena(lmp)

above exp. is excellent for connection less and connection
oriented.
data adapter performs almost five steps
1- open(create)connection
2- fatch the data
3- generate xml file of data
4- fill xml data file into the dataset by fill()method
5- closed the connection.

Answer / bapu thore

connection less vs connection oriented

Diff b/w DataReader,Dataset and Data table?

5 Answers   HCL,

---

What is method to get XML and schema from Dataset? getXML() and get Schema ()

0 Answers  

---

What are all features of ADO.Net?

0 Answers  

---

What is serialization and de-serialization in .net?

0 Answers  

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  

---

What is ado recordset?

0 Answers  

---

Explain how to call the sql commands asynchronously in ado.net version 2.0?

0 Answers  

---

Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,

---

what is meant by connection pooling and event pumbling in ado.net

3 Answers   TCS,

---

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

---

What is the hierarchy of data in databases?

0 Answers  

---

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,

---