can you load the more than one table in the datareader?
Koteswararao Mallisetti
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 .