DataTable和List互转
/// <summary>
/// list转datatable
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="collection"></param>
/// <returns></returns>
public DataTable ListToDt<T>(IEnumerable<T> collection)
{
var props = typeof(T).GetProperties();
var dt = new DataTable();
dt.Columns.AddRange(props.Select(p => new DataColumn(p.Name, p.PropertyType)).ToArray());
if (collection.Count() > 0)
{
for (int i = 0; i < collection.Count(); i++)
{
ArrayList tempList = new ArrayList();
foreach (PropertyInfo pi in props)
{
object obj = pi.GetValue(collection.ElementAt(i), null);
tempList.Add(obj);
}
object[] array = tempList.ToArray();
dt.LoadDataRow(array, true);
}
}
return dt;
}
list转datatable
public class DtToList<T> where T : new()
{
/// <summary>
/// datatable转list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static List<T> ConvertToModel(DataTable dt)
{
List<T> ts = new List<T>();// 定义集合
Type type = typeof(T); // 获得此模型的类型
string tempName = "";
foreach (DataRow dr in dt.Rows)
{
T t = new T();
PropertyInfo[] propertys = t.GetType().GetProperties();// 获得此模型的公共属性
foreach (PropertyInfo pi in propertys)
{
tempName = pi.Name;
if (dt.Columns.Contains(tempName))
{
if (!pi.CanWrite) continue;
object value = dr[tempName];
if (value != DBNull.Value)
pi.SetValue(t, value, null);
}
}
ts.Add(t);
}
return ts;
}
}
datatable转list
最新文章
- Jpa实体VO使用继承的实体的做法@MappedSuperclass注解的使用
- EF增删改查操作
- html5拖拽
- How To Fix – Mcrypt PHP extension required in Laravel on Mac OS X (No MAMP)
- 转载 ASP.NET MVC中使用ASP.NET Identity
- eclipse中svn插件的安装
- 深入了解session
- codechef Chef and The Right Triangles 题解
- 获取wpf datagrid当前被编辑单元格的内容
- HTTP header 介绍
- 数位dp初步——数位dp的两种方式
- java1环境与简介
- SaaS应用十大关键NFR - 第2部分
- git获取远程服务器的指定分支
- python笔记---数据基础类型
- Django MTV simple_tag filter inclusion_tag
- POJ 2965贪心神解
- Tempter of the Bone dfs+剪枝
- 关于bfs与dfs的标记区别
- np.arrange用法