This post has been moved to beyondrelational.
Jul 31, 2010
Jul 17, 2010
There always be case where one procedure returns more then one result set. Getting those data in DataSet is lazy way of coding, best way to do that is using DataReader. DataReader having method call NextResult which allows us to read next result set if any.
Read more from here.