A situation where we want to pass 2 or more querries to a
DataReader like "Select * from Table1;Select * from Table2"

we have do the following things

while(datareader.nextResultSet())
{
 while(datareader.read())
  {
    .......Processing of result set..
  }
}