yes we can write the 2 select statements in single sqlcommand object separated with semicolon then it possible ,once we move the second table you can't come back to first table that is the problem as like rows .
No Only one table can load in the DataReader, But Dataset we can load multiple datatables.