2
Reply

can you load the more than one table in the datareader?

    No Only one table can load in the DataReader, But Dataset we can load multiple datatables.

    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 .