Retrieving Multiple Record Sets Through a DataReader May 23, 2017 If a stored procedure returns multiple record sets, and if you are using the DataReader to retrieve the results, you can use the NextResult method of the DataReader to iterate