使用SqlDataReader对象的NextResult方法读取T-SQL多个结果集

Create PROCEDURE Pro_MoreResult
AS
	--第一个结果集
	Select Top 10 CompanyName From Customers

	--第二个结果集
	Select Top 10 LastName+','+FirstName From Employees
GO

using (SqlConnection conn = new SqlConnection("Data Source=192.168.0.111;Initial Catalog=Northwind;User ID=sa;Password=sa;min pool size=4;max pool size=100;"))
{
    conn.Open();

    SqlCommand cmd = new SqlCommand();
    cmd.Connection = conn;
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.CommandText = "Pro_MoreResult";

    SqlDataReader sdr = cmd.ExecuteReader();
    //第一个结果集
    while (sdr.Read())
    {
        Response.Write(sdr[0].ToString() + "<br/>");
    }
    Response.Write("<br/>------------------------------------<br/><br/>");
    //第二个结果集
    sdr.NextResult();
    while (sdr.Read())
    {
        Response.Write(sdr[0].ToString() + "<br/>");
    }
    sdr.Close();

    conn.Close();
}