How to read multiple resultsets into a set of data readers?

  • Thread starter Thread starter Frank Rizzo
  • Start date Start date
F

Frank Rizzo

I have a stored proc that returns 5 resultsets. How can I read each
resultset into a separate data reader?

Thanks
 
Bot quite sure what you are asking. However, if you make 1 proc call that
returns 5 result sets, you need to call NextResult() on your DataReader to
advance to the next result set. Pseudo code below:

//initialise connection and command
DataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
//now in 1st result set
//process 1st
if (reader.NextResult())
{
//2nd
}

//etc.
}

If you want 5 separate data readers, call the process separately.

HTH
Dan
 
Back
Top