List 转DataTable解决system.DBNull 问题

最新推荐文章于 2020-07-30 23:35:38 发布

炫爱小七

最新推荐文章于 2020-07-30 23:35:38 发布

阅读量597

点赞数

分类专栏： NPOI

本文链接：https://blog.csdn.net/qq_20258573/article/details/86527771

版权

NPOI 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

#region 反射List To DataTable
///
/// 将List集合类转换成DataTable
///
/// 集合
///
public static DataTable ListToDataTable(IList list)
{
DataTable result = new DataTable();
if (list.Count > 0)
{
PropertyInfo[] propertys = list[0].GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
//获取类型
Type colType = pi.PropertyType;
//当类型为Nullable<>时
if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition() == typeof(Nullable<>)))
{

colType = colType.GetGenericArguments()[0];

}
Attribute att = pi.GetCustomAttribute(typeof(NameAttribute), true);
if (att!=null)
{
NameAttribute nameAtt = (NameAttribute)att;
result.Columns.Add(nameAtt.title, colType);
}
else
{
result.Columns.Add(pi.Name, colType);
}

}

for (int i = 0; i < list.Count; i++)
{
ArrayList tempList = new ArrayList();
foreach (PropertyInfo pi in propertys)
{
object obj = pi.GetValue(list[i], null);
tempList.Add(obj);
}
object[] array = tempList.ToArray();
result.LoadDataRow(array, true);
}
}
return result;
}
#endregion