2 Resultsets in Datareader

Question

Hi,

Is it possible to store more than 2 resultsets in Datareader?I have different methods which returns datareader,can i store resultsets of them in the same datareader? (I use vs 2008 )

Answer 1

Yes, send the query as below:

    string select = "select * from Categories; select * from customers";
    SqlCommand command = new SqlCommand ( select, conn );
    conn.Open ();
    SqlDataReader reader = command.ExecuteReader ();

You can use the two results:

do
{
  while ( reader.Read () )
  {
    Console.WriteLine ( "{0}\t\t{1}", reader[0], reader[1] );
  }
}while ( reader.NextResult () );

The inner while iterates over the individual records from a resultset; the NextResult() jumps to the next resultset.