Exemplo n.º 1
0
        /// <summary>
        /// 获取所有学生
        /// </summary>
        /// <returns></returns>
        public List <Student> GetStudentList()
        {
            List <Student> students = new List <Student>();



            SqlDataReader reader = dao.GetDataReader("select StudentNo,StudentName from Student");

            while (reader.Read())
            {
                Student student = new Student();
                student.StudentNo   = reader["StudentNo"].ToString();
                student.StudentName = reader["StudentName"].ToString();
                // 组装到学生集合列表中
                students.Add(student);
            }
            // 关闭读取器
            reader.Close();

            // 关闭连接
            dao.connection.Close();
            return(students);
        }