problem in using OleDbDataReader

Question

I have two tables called master and child tabels.For each record in the master table i have to get the information in corresponding child table.I am using the same connection.SO when i am trying to get information from child without closing the DbReader in Master table(I need master DbReader also.So I am intensionally not closing it) it is giving me error that the connection is already in use.

Tanvir Huda · Answer

Yeah U cant use the same reader for the two query once u are runing one under another. So  for the second query u have to instantiate a new datareader. if u run the queries separely one after another that should be working fine.