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

[Frank Rizzo]

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

Thanks

 

[Guest]

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