/// <summary> /// List集合转DataTable /// </summary> /// <typeparam name="T">实体类型</typeparam> /// <param name="list">传入集合</param> /// <returns>返回datatable结果</returns> public static DataTable ListToTable<T>(List<T> list) { Type tp = typeof(T); PropertyInfo[] proInfos = tp.GetProperties(); DataTable dt = new DataTable(); foreach (var item in proInfos) { dt.Columns.Add(item.Name, item.PropertyType); //添加列明及对应类型 } foreach (var item in list) { DataRow dr = dt.NewRow(); foreach (var proInfo in proInfos) { object obj = proInfo.GetValue(item); if (obj == null) { continue; } dr[proInfo.Name] = obj; } dt.Rows.Add(dr); } return dt; }
更新待续!!!