多个数据集的查询,关键是NextResult()方法
using System.Data.SqlClient;
namespace ADONETDemo
{
/// <summary>
/// 多个结果集查询
/// </summary>
internal class MultipleResultSetQueries
{
public static void Main(string[] args)
{
//连接语句
string connStr = "server = localhost; database = MyPhoneList; uid = 123; pwd = 123";
//连接对象
SqlConnection sqlConn = new SqlConnection(connStr);
//打开连接
sqlConn.Open();
//查询语句
string queryStr = "select CategoryId, CategoryName from PCategary; select PName, Gender from PhoneList;";
//command对象
SqlCommand sqlCom = new SqlCommand(queryStr, sqlConn);
//使用ExecuteReader()查询
SqlDataReader dataReader = sqlCom.ExecuteReader();
//输出第一个数据集的数据
while (dataReader.Read())
{
System.Console.WriteLine(dataReader[0] + "" + dataReader[1]);
}
System.Console.WriteLine("---------------------");
//判断是否存在下一个数据集
if (dataReader.NextResult())
{
while (dataReader.Read())
{
System.Console.WriteLine(dataReader[0] + "" + dataReader[1]);
}
}
//关闭查询器
dataReader.Close();
//关闭连接
sqlConn.Close();
System.Console.ReadLine();
}
}
}