Answer Posted / vrsanaidu

Yes, we can have multiple result set means multiple
datatable data in one datareader..., code as below

SqlConnection con = new
SqlConnection(ConfigurationSettings.AppSettings["con"]);
SqlCommand cmd = new SqlCommand("SELECT SiteName FROM
Sites;SELECT SiteCode FROM Sites", con);
cmd.Connection.Open();
SqlDataReader r = cmd.ExecuteReader();
do {
while(r.Read()) {
Response.Write(r.GetString(0) + "<br>");
}
} while (r.NextResult());


r.Close();
con.Close();
cmd = null;
r = null;
con = null;

Is datareader faster than datatable?

1017

---

What are the different row versions available in table?

1029

---

What is ole in vb?

950

---

Is ado.net an orm?

1006

---

What are all the different methods under sqlcommand?

1030

---

What is sqldatasource?

978

---

What are the methods of XML dataset object?

1061

---

How to add an aggregate column?

1064

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

1105

---

What is the difference between Data adaptor and Data set?

1095

---

Explain sqlconnection object?

1065

---

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

1068

---

What is the difference between Command and CommandBuilder object?

1341

---

How can we load multiple tables in a dataset?

1237

---

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1105

---