public void Test()
{
string sql = "select * from StudentClass";
DataTable dt = dBHelper.ExecuteReader(sql);
List<StudentClass> classes = new List<StudentClass>();
foreach (DataRow dr in dt.Rows)
{
StudentClass stuClass = new StudentClass();
stuClass.ClassId = (int)dr["ClassId"];
stuClass.ClassName = dr["ClassName"].ToString();
if (dr["testTime"] != DBNull.Value)
{
stuClass.TestTime = Convert.ToDateTime(dr["testTime"].ToString());
}
if (dr["num"] != DBNull.Value)
{
stuClass.num = int.Parse(dr["num"].ToString());
}
classes.Add(stuClass);
}
}
class StudentClass
{
public int ClassId { get; set; }
public string ClassName { get; set; }
public DateTime TestTime { get; set; }
public int num { get; set; }
}
备注:如果数据库里面的值为null,则dataTable中对应的值为dbnull.value,如dr["num"],这个值转成string之后为空字符串。