DataTable转换成List形式
参考下
public static List <T> DataTableToObject <T>(List <T> xtraList, DataTable xtraDataTable) where T : new()
{
xtraList = new List <T>();
foreach (DataRow dr in xtraDataTable.Rows)
{
T _t = new T();
Type _type = _t.GetType();
foreach (DataColumn dc in xtraDataTable.Columns)
{
PropertyInfo info = _type.GetProperty(dc.ColumnName);
info.SetValue(_t, dr[dc.ColumnName], null);
}
xtraList.Add(_t);
}
return xtraList;
}
public static List <T> DataTableToObject <T>(List <T> xtraList, DataTable xtraDataTable) where T : new()
{
xtraList = new List <T>();
foreach (DataRow dr in xtraDataTable.Rows)
{
T _t = new T();
Type _type = _t.GetType();
foreach (DataColumn dc in xtraDataTable.Columns)
{
PropertyInfo info = _type.GetProperty(dc.ColumnName);
info.SetValue(_t, dr[dc.ColumnName], null);
}
xtraList.Add(_t);
}
return xtraList;
}