SQL Server ADO.NET多结果查询

StudentClass.cs先不变

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApp
{
    class Program
    {
        //链接字符串--链接数据库用
        private static readonly string connString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=StudentManger;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
        #region 读取单个对象


        //static void Main(string[] args)
        //{
        //    //准备好SQL语句
        //    string sql = "select ClassID,ClassName from StudentClass where ClassId=1";

        //    //链接ADO.NETZUO数据查询
        //    StudentClass student = new StudentClass();
        //    SqlConnection conn = new SqlConnection(connString);//链接数据库(链接数据库实例)
        //    SqlCommand cmd = new SqlCommand(sql, conn);//发送sql命令

        //    conn.Open();//打开链接
        //    //CommandBehavior.CloseConnection 检测并自动关闭数据库链接
        //   SqlDataReader reader= cmd.ExecuteReader(CommandBehavior.CloseConnection);

        //    //解析数据
        //    if(reader.Read())
        //    {
        //        student = new StudentClass()
        //        {
        //            ClassId = Convert.ToInt32(reader["ClassId"]),
        //            ClassName = reader["ClassName"].ToString()

        //        };
        //    }

        //    //展示数据
        //    Console.WriteLine("班级ID:" + student.ClassId+"   班级名称:"+student.ClassName);
        //    Console.Read();
        //}
        #endregion

        #region 读取多个对象
        static void Main(string[] args)
        {
            //准备好SQL语句
            string sql = "select ClassID,ClassName from StudentClass";

            //链接ADO.NETZUO数据查询
          
            SqlConnection conn = new SqlConnection(connString);//链接数据库(链接数据库实例)
            SqlCommand cmd = new SqlCommand(sql, conn);//发送sql命令
            List<StudentClass> sutlist = new List<StudentClass>();

            conn.Open();//打开链接
            //CommandBehavior.CloseConnection 检测并自动关闭数据库链接
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            //解析数据
            while(reader.Read())
            { 
                StudentClass student = new StudentClass()
                {
                    ClassId = Convert.ToInt32(reader["ClassId"]),
                    ClassName = reader["ClassName"].ToString()
                };
                sutlist.Add(student);

            }

            //展示数据
            foreach (var student in sutlist)
            {
                Console.WriteLine("班级ID:" + student.ClassId + "   班级名称:" + student.ClassName);
            }
          
        }
        #endregion
    }
}