Answer Posted / anup kumar

yes, it is posible. by using NextResult() method of
sqldatareader.

sqlcommand cmd = new sqlcommand("select id from emp ; select
dptid from dpt",YourConnection);
//check connection status and open the connection
if(rdr.hasrows)
{
//read id from emp
}
if (rdr.HasRows() == true)
{
//read dptid from dpt
}
//close the connection

What is the provider being used to access oracle database?

945

---

What is disconnected scenario in entity framework?

1064

---

What is difference between sqldatareader and sqldataadapter?

895

---

What is basic use of data view?

948

---

What is the difference between data grid and data repeater?

1013

---

What are dataproviders?

912

---

What is linq and entity framework?

946

---

Define atomicity?

977

---

Explain ODP.net

945

---

Which is faster entity framework or ado.net?

884

---

Explain the different row versions available in table?

989

---

What is execute scalar in ado.net?

911

---

What are the 3 major types of connection objects in ado.net?

947

---

What are all features of ADO.Net?

940

---

Which method is used by command class to execute SQL statements that return single value?

990

---