将实体类集合转换为DataTable
通过反射将实体类转化为DataTable类型

using System.Reflection;

using System.Data;



/// <summary>
/// 实体类转换成DataTable
/// 调用示例：DataTable dt= FillDataTable(Entitylist.ToList());
/// </summary>
/// <param name="modelList">实体类列表</param>
/// <returns></returns>
public DataTable FillDataTable<T>(List<T> modelList)
{
if (modelList == null || modelList.Count == 0)
{
return null;
}
DataTable dt = CreateData(modelList[0]);//创建表结构

foreach (T model in modelList)
{
DataRow dataRow = dt.NewRow();
foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
{
dataRow[propertyInfo.Name] = propertyInfo.GetValue(model, null);
}
dt.Rows.Add(dataRow);
}
return dt;
}
/// <summary>
/// 根据实体类得到表结构
/// </summary>
/// <param name="model">实体类</param>
/// <returns></returns>
private DataTable CreateData<T>(T model)
{
DataTable dataTable = new DataTable(typeof(T).Name);
foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
{
if (propertyInfo.Name != "CTimestamp")//些字段为oracle中的Timesstarmp类型
{

dataTable.Columns.Add(new DataColumn(propertyInfo.Name, propertyInfo.PropertyType));
}
else
{
dataTable.Columns.Add(new DataColumn(propertyInfo.Name, typeof(DateTime)));
}
}
return dataTable;
}
如上是一个将实体类集合转换为DataTable类型的方法。。但是我用在我的方法里执行不进去，谁能找找原因，或者给出正确的。方法。 Datatable?实体类
[解决办法]

class Program
    {
        static void Main(string[] args)
        {
            var list = new List<Demo> {  
                   new Demo{ id=1,age=18, name="Tim"},  
                    new Demo{ id=2,age=22, name="Allen"},  
                   new Demo{ id=3,age=24, name="Jim"}  
               };
            var dt = list.ToDataTable();
          
        }
    }
    static class Extensions
    {
        internal static DataTable ToDataTable<T>(this IList<T> list)
        {
            Type elementType = typeof(T);

            var t = new DataTable();

            elementType.GetProperties().ToList().ForEach(propInfo => t.Columns.Add(propInfo.Name, Nullable.GetUnderlyingType(propInfo.PropertyType) ?? propInfo.PropertyType));
            foreach (T item in list)
            {
                var row = t.NewRow();
                elementType.GetProperties().ToList().ForEach(propInfo => row[propInfo.Name] = propInfo.GetValue(item, null) ?? DBNull.Value); 
 
                t.Rows.Add(row);
            }
            return t;
        }
    }
    class Demo
    {
        public int id { get; set; }
        public string name { get; set; }
        public int age { get; set; }
    }