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
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the differences between OLEDB and SQLClient Providers?
How would you connect to database using .NET?
What does executereader return?
How do you connect to sql server database without using sqlclient?
What is the use of connection object in ado.net?
What are dcl commands?
What is ole db and odbc?
What is connection string?
Explain executenonquery?
What are the drawbacks of using ado.net?
What are the different row versions available in table?
What is data view and variable view?
Explain ODP.net
What are the data providers in ADO.NET framework?
What connected data?