ADO.NET— 使用List集合封装多个同类型对象

 public List<Student> GetAllStudent()
        {
            string sql = "select StudentName,Birthday,StudentAddress,ClassId from Students";
            SqlDataReader objReader=SQLHelper.getReader(sql);
            List<Student> stuList = new List<Student>();
            while (objReader.Read())
            {
                //封装对象
                Student objStu = new Student()
                {
                    StudentName = objReader["StudentName"].ToString(),
                    Birthday = Convert.ToDateTime(objReader["Birthday"]),
                    StudentAddress = objReader["StudentAddress"].ToString(),
                    ClassId = Convert.ToInt16(objReader["ClassId"])
                };
                stuList.Add(objStu);
            }
            objReader.Close();
            return stuList;
        }

        static void Main(string[] args)
        {
            StudentService objstuService = new StudentService();
            List<Student> stuList = objstuService.GetAllStudent();
            if (stuList.Count != 0)
            {
                foreach (Student item in stuList )
                    Console.WriteLine(item.StudentName+" "+item.Birthday+" "+item.StudentAddress+" "+item.ClassId);
            }
            else
                Console.WriteLine("没有要显示的数据");
            Console.ReadLine();

        }