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
Explain how to pass multiple tables in datasets simultaneously?
How does ado.net work?
What is datasource in ado.net?
What is sql command in ado net?
What is ado.net object model?
What is an orm, and why would you use one instead of plain old ado.net?
How to add a check box or a dropdown list to a column in a datagrid?
Which is faster dataset or datareader?
What is the purpose of using adodb?
What is the difference between Command and CommandBuilder object?
What are three methods for displaying data in a syncfusion datagrid
What is the use of SqlCommand object?
How can we check that some changes have been made to dataset since it was loaded?
How do you implement locking concept for dataset?
What are the drawbacks of using ado.net?