List转Datatable 新方法

方法1，最简单的转换

DataTable dt = new DataTable();            

dt.Columns.Add("id");            

dt.Columns.Add("name");

dt.Rows.Add(new object[]{ 0,"顶层菜单"});            

foreach (var cm in comdList)            

{            

DataRow dr = dt.NewRow();             

dr["id"] = cm.SYS_COMMANDS_ID;             

dr["name"] = cm.TXT_COMMANDTITLE;            

dt.Rows.Add(dr);            

}

方法2，建立类

 

public static class DataTableExtensions

    {

        /// <summary>   

 

        /// 转化一个DataTable   

 

        /// </summary>   

 

        /// <typeparam name="T"></typeparam>   

        /// <param name="list"></param>   

        /// <returns></returns>   

        public static DataTable ToDataTable<T>(this IEnumerable<T> list)

        {

 

            //创建属性的集合   

            List<PropertyInfo> pList = new List<PropertyInfo>();

            //获得反射的入口   

 

            Type type = typeof(T);

            DataTable dt = new DataTable();

            //把所有的public属性加入到集合 并添加DataTable的列   

            Array.ForEach<PropertyInfo>(type.GetProperties(), p => { pList.Add(p); dt.Columns.Add(p.Name, p.PropertyType); });

            foreach (var item in list)

            {

                //创建一个DataRow实例   

                DataRow row = dt.NewRow();

                //给row 赋值   

                pList.ForEach(p => row[p.Name] = p.GetValue(item, null));

                //加入到DataTable   

                dt.Rows.Add(row);

            }

            return d