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

 1  public List<Student> GetAllStudent()
 2         {
 3             string sql = "select StudentName,Birthday,StudentAddress,ClassId from Students";
 4             SqlDataReader objReader=SQLHelper.getReader(sql);
 5             List<Student> stuList = new List<Student>();
 6             while (objReader.Read())
 7             {
 8                 //封装对象
 9                 Student objStu = new Student()
10                 {
11                     StudentName = objReader["StudentName"].ToString(),
12                     Birthday = Convert.ToDateTime(objReader["Birthday"]),
13                     StudentAddress = objReader["StudentAddress"].ToString(),
14                     ClassId = Convert.ToInt16(objReader["ClassId"])
15                 };
16                 stuList.Add(objStu);
17             }
18             objReader.Close();
19             return stuList;
20         }

 1         static void Main(string[] args)
 2         {
 3             StudentService objstuService = new StudentService();
 4             List<Student> stuList = objstuService.GetAllStudent();
 5             if (stuList.Count != 0)
 6             {
 7                 foreach (Student item in stuList )
 8                     Console.WriteLine(item.StudentName+" "+item.Birthday+" "+item.StudentAddress+" "+item.ClassId);
 9             }
10             else
11                 Console.WriteLine("没有要显示的数据");
12             Console.ReadLine();
13 
14         }

 

转载于:https://www.cnblogs.com/Linglinlin/p/7170806.html