How to get results if a stored procedure returns multiple result sets

   Mode one: Use SqlDataAdapter
            SqlDataAdapter SDA = new SqlDataAdapter ();
            DataSet ds = new DataSet ();
            Sda. Fill (DS);//fill DataSet: If the result set has more than one, correspond to multiple table//In the DataSet
 
            two: Use SqlDataReader
            sqldatareader SDR = cmd. ExecuteReader ();
            if (SDR). HasRows)
            {while
                (SDR). Read ())
                {
                    //reads the first result set
                }
                if (SDR). NextResult ())
                {while
                    (SDR). Read ())
                    {
                        //reads the second result set
                    }
                }
                //if (SDR). NextResult ()) can continue to read multiple result sets (if any)
            }

The stored procedure returns a result set of two select at a time, how to obtain

http://bbs.csdn.net/topics/390282883

How to use a result set SQL instance returned by another stored procedure in a stored procedure

http://blog.csdn.net/baodi_z/article/details/38822115

The stored procedure returns a result set of two select at a time, how to obtain