class BB
{
public int ID { get; set; }
public string Name { get; set; }
public int Age { get; set; }
//DataTable转为list
public List<T> Get<T>(DataTable dt) where T : new()
{
List<T> list = new List<T>();
foreach (DataRow item in dt.Rows)
{
T t = new T();
//给属性赋值
Type tt = typeof(T);
var ps = tt.GetProperties();//获取属性
//循环输出
foreach (var ite in ps)
{
ite.SetValue(t, item[ite.Name]);
}
list.Add(t);
}
return list;
}
//list转为DataTable
public DataTable Get<T>(List<T> list) where T : new()
{
DataTable dt = new DataTable();
Type type = typeof(T);
PropertyInfo[] p = type.GetProperties();
foreach ( var item in p)
{
DataColumn dc = new DataColumn(item.Name, item.PropertyType);
dt.Columns.Add(dc);
}
foreach (var item in list)
{
DataRow dr = dt.NewRow();//创建一个新行
for (int i = 0; i < p.Length; i++)
{
dr[i] = p[i].GetValue(item);//根据名称获取值
}
dt.Rows.Add(dr);
}
return dt;
}
}
原文:https://www.cnblogs.com/lrzb/p/11800002.html