public static System.Data.DataTable LinqToDataTable<T>(IEnumerable<T> data) { var dt = new System.Data.DataTable(); var ps = typeof(T).GetProperties().ToList(); ps.ForEach(p => dt.Columns.Add(p.Name, p.PropertyType)); foreach (T t in data) { var dr = dt.NewRow(); var vs = from p in ps select p.GetValue(t, null); var ls = vs.ToList(); int i = 0; ls.ForEach(c => dr[i++] = c); dt.Rows.Add(dr); } return dt; } public static System.Data.DataTable ToDataTable<T>(IEnumerable<T> data) { var dt = new System.Data.DataTable(); var ps= System.ComponentModel.TypeDescriptor.GetProperties(typeof(T)); foreach (System.ComponentModel.PropertyDescriptor dp in ps ) dt.Columns.Add(dp.Name, dp.PropertyType); foreach (T t in data) { var dr = dt.NewRow(); foreach (System.ComponentModel.PropertyDescriptor dp in ps) dr[dp.Name] = dp.GetValue(t); dt.Rows.Add(dr); } return dt; }
原文:http://www.cnblogs.com/volts0302/p/5197151.html