Answer Posted / karna

data set a collection of datatables and we can edit the
data in the datatables and the same can be persisted to
databae using adapter in the disconnected maner by using
commandbuilder or insert,update,select command.

datareader is just the container for data,its readonly and
forwardonly curosr.this follows connected architecture,that
means when we are reading data from datareader at that time
connection should be kept open.

data reader can hold data from multiple tables and
datareader can hold more than one table.

Example:

string query="select * from employee;select * from student";
sqlcommand cmd=new sqlcommand(query,connection);
sqldatareader dr=cmd.executeReader();
if(dr.hasrows)
{
dr.read();
gridview1.DataSource=dr;
gridview1.Databind();
if(dr.nextresult)
{
gridview2.datasource=dr;
gridview2.databind();
}
}
dr'colse();
connection.close();

if anybody have any doubts,mail to me on karun84@gmail.com

How can we serialize the dataset object?

1048

---

What are all components of ADO.Net data provider?

1108

---

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

1037

---

What are basic methods of dataadapter?

1010

---

How to find the given query is optimised one or not?

1018

---

What does ado stand for?

944

---

Some important instruction regarding ADO.NET connection string ?

1044

---

how we can fire event in databound coulm in datagfrid withot using button?

1021

---

What is ado.net in vb net?

959

---

What is datatable in ado.net?

1005

---

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

1106

---

How can we check that some changes have been made to dataset since it was loaded?

1015

---

Explain what are acid properties?

1052

---

How does ado.net work?

980

---

Does dapper use ado.net?

1068

---