C# IEnumerable＜T＞转换成DataTable

余音Yoin

已于 2023-11-20 15:39:36 修改

阅读量224

点赞数

分类专栏：【开发笔记】C# 文章标签： c#

于 2023-11-09 15:38:29 首次发布

本文链接：https://blog.csdn.net/qq_43576891/article/details/134313313

版权

【开发笔记】C# 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

 public static DataTable ToDataTable<T>(this IEnumerable<T> list)
{
    DataTable dataTable = new DataTable();
    PropertyInfo[] array = null;
    foreach (T item in list)
    {
        if (array == null)
        {
            array = item.GetType().GetProperties();
            PropertyInfo[] array2 = array;
            foreach (PropertyInfo propertyInfo in array2)
            {
                Type type = propertyInfo.PropertyType;
                if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable<>))
                {
                    type = type.GetGenericArguments()[0];
                }

                dataTable.Columns.Add(new DataColumn(propertyInfo.Name, type));
            }
        }

        DataRow dataRow = dataTable.NewRow();
        PropertyInfo[] array3 = array;
        foreach (PropertyInfo propertyInfo2 in array3)
        {
            dataRow[propertyInfo2.Name] = ((propertyInfo2.GetValue(item, null) == null) ? DBNull.Value : 	propertyInfo2.GetValue(item, null));
        }

        dataTable.Rows.Add(dataRow);
    }

    return dataTable;
}