GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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 02:06:49 #3
 jebasingh_23   Member Since: December 2005    Total Comments: 1 

RE: retrieve two tables of data at a time by using data reader
 
The datareader will always return the first result only. If you want to get the second table then you need to use dr.NextResult() .
     

 

Back To Question