List<Student> list = new List<Student>();
string sql = "select * from [Student$]";
DataSet ds = OleDBHelper.GetDataSet(sql,path);
DataTable dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
list.Add(new Student()
{
StudentName = row["姓名"].ToString(),
Gender=row["性别"].ToString(),
Birthday = Convert.ToDateTime(row["出生日期"]),
Age=DateTime.Now.Year- Convert.ToDateTime(row["出生日期"]).Year,
CardNo = row["考勤卡号"].ToString(),
StudentIdNo = row["身份证号"].ToString(),
PhoneNumber = row["电话号码"].ToString(),
StudentAddress = row["家庭住址"].ToString(),
ClassId = Convert.ToInt32(row["班级编号"])
});
}
return list;
string sql = "select * from [Student$]";
DataSet ds = OleDBHelper.GetDataSet(sql,path);
DataTable dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
list.Add(new Student()
{
StudentName = row["姓名"].ToString(),
Gender=row["性别"].ToString(),
Birthday = Convert.ToDateTime(row["出生日期"]),
Age=DateTime.Now.Year- Convert.ToDateTime(row["出生日期"]).Year,
CardNo = row["考勤卡号"].ToString(),
StudentIdNo = row["身份证号"].ToString(),
PhoneNumber = row["电话号码"].ToString(),
StudentAddress = row["家庭住址"].ToString(),
ClassId = Convert.ToInt32(row["班级编号"])
});
}
return list;