ADO.NET—返回多个结果集查询

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data;
using System.Data.SqlClient;

namespace ADO.NETDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            //定义连接字符串
            string connstring = "Server=F-PC\\SQLEXPRESS;DataBase=StudentManageDB;Uid=sa;Pwd=123456";
            //创建连接对象
            SqlConnection conn = new SqlConnection(connstring);

            //编写SQL语句
            string sql = "select StudentId,StudentName from Students;select ClassId,ClassName from StudentClass";

            //创建command对象
            SqlCommand cmd = new SqlCommand(sql, conn);

            //打开连接
            conn.Open();

            //执行操作
            SqlDataReader objReader = cmd.ExecuteReader();
            //读取第一个结果集
            while (objReader.Read())
            {
             Console.WriteLine(objReader["StudentId"].ToString() + "\t" + objReader["StudentName"].ToString());
            }
            Console.WriteLine("----------------------");
            if (objReader.NextResult())
            while (objReader.Read())
             {
             Console.WriteLine(objReader["ClassId"].ToString() + "\t" + objReader["ClassName"].ToString());
             }
            //关闭连接
            objReader.Close();
            conn.Close();

            
            Console.ReadLine();

        }
    }
}