| |
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 |
| June 06, 2008 03:06:29 |
#7 |
| kumar2ch |
Member Since: June 2008 Total Comments: 2 |
RE: retrieve two tables of data at a time by using data reader
|
Yes this possiable to retreive the data from tw tables
useing datareader
syntax:
in sql
select * from EmployeeMaster,Department
sqlcommaned cmd=new sqlcommaned ();
cmd.commanedText="select * from EmployeeMaster,Department";
sqldatareader dr=cmd.ExecuteReader(); |
| |
Back To Question | |
