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 is entity framework different from ado.net?

905

---

What are two types of transaction supported by ado.net?

937

---

What is difference between sqldatareader and sqldataadapter?

892

---

What is difference between datagridview and datagrid control in winforms?

955

---

Define atomicity?

974

---

What does sqldatareader return?

914

---

What are the difference between readonly vs. Const?

940

---

Define connection string?

1013

---

What is the difference between Datareader and Dataset?

1026

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

945

---

What are the ado.net components?

965

---

What are the ado.net connection pooling parameters?

906

---

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

1086

---

What is data relation in ado.net?

993

---

What are the advantages and drawbacks of using ado.net?

1042

---