| |
GeekInterview.com > Interview Questions > Microsoft > Ado.NET
| Print | |
Question: retrieve two tables of data at a time by using data reader
Answer: One interview I faced a Q:
how can i retrieve two tables of data at a time by using data reader?
Data reader read and forward only, how is
it possible to get 2 tables of data at a time |
| November 11, 2007 10:17:03 |
#1 |
| Ravindra Thakur |
Member Since: Visitor Total Comments: N/A |
RE: retrieve two tables of data at a time by using dat...
|
Hi,
If we execute 2 select command either in stored procedure or in select command and then executereader method fired of command object. it return 2 tables in datareader.
like :
string str="Select * from a;select * from b";
cmd.commandtext=str;
dr=cmd.executereader();
Now it return 2 tables in datareader (dr). |
| |
Back To Question | |
