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;

What is typed dataset ?

1183

---

Explain the different row versions available in table?

1063

---

What is execute scalar in ado.net?

965

---

What are the different ado.net namespaces are available in .net?

1008

---

What are all the different methods under sqlcommand?

986

---

Explain executenonquery?

1135

---

What is the use of Dataview?

1133

---

What is microsoft ole db provider for sql server?

933

---

How to creating a SqlCommand Object?

1141

---

Give an example that shows how to execute a stored procedure in ado.net?

1072

---

Define data access layer?

958

---

What is Data view?

1079

---

How does entity framework work?

922

---

Define Execute Scalar?

1020

---

What is ado.net connection?

962

---