string connstr = "data source=WIN-10AFVI27V7T;initial catalog=School;user id=sa;password=admin;";
using (SqlConnection conn = new SqlConnection(connstr))
{
string sql = "select * from T_Class;select * from T_Student";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
#region 读取多个结果集的方法
//do···while do先来读取第一个结果集 while(reader.NextResult())中判断是否还有一个结果集,如果有在do中再次读取第二个结果集,依次类推···
do
{
if (reader.HasRows)
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Response.Write(reader.GetValue(i));
}
Response.Write("<br/>");
}
}
}
while (reader.NextResult());
#endregion
#region 读取一个结果集的方法
//if (reader.HasRows)
//{
// while (reader.Read())
// {
// //内层循环获取列
// for (int i = 0; i < reader.FieldCount; i++)
// {
// Response.Write(reader.GetValue(i));
// }
// Response.Write("<br/>");
// }
// Response.Write("有查询结果集!");
//}
#endregion
}
}
}