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
"Frank Rizzo" wrote:
I have a stored proc that returns 5 resultsets. How can I read each
resultset into a separate data reader?
Thanks