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

Define bubbled event?

875

---

What is ado connection?

906

---

What are good ado.net object to replace to ado recordset object.

1045

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

929

---

Explain what is datagrid with an example?

1046

---

What is dao and ado?

886

---

Explain the dataadapter class in ado.net?

1140

---

What is the difference between ado.net and entity framework?

996

---

Which ado.net object is very fast in getting data from the database?

1058

---

Why do we serialize data?

889

---

Define executenonquery?

869

---

What is the difference between Optimistic and Pessimistic locking?

931

---

What is ado.net and its features?

930

---

How to bind the controls(best practice) comboboxes to the data in the dataset?

1010

---

What are dcl commands?

967

---