csharp:Conversion Between DataTable and List/// <summary> /// http://www.codePRoject.com/Tips/784090/Conversion-Between-DataTable-and-List-in-Csharp /// </summary> public static class ExtensionUtility { /// <summary> /// Converts List To DataTable /// </summary> /// <typeparam name="TSource"></typeparam> /// <param name="data"></param> /// <returns></returns> public static DataTable ToDataTable<TSource>(this IList<TSource> data) { DataTable dataTable = new DataTable(typeof(TSource).Name); PropertyInfo[] props = typeof(TSource).GetProperties(BindingFlags.Public | BindingFlags.Instance); foreach (PropertyInfo prop in props) { dataTable.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } foreach (TSource item in data) { var values = new object[props.Length]; for (int i = 0; i < props.Length; i++) { values[i] = props[i].GetValue(item, null); } dataTable.Rows.Add(values); } return dataTable; } /// <summary> /// Converts DataTable To List /// </summary> /// <typeparam name="TSource"></typeparam> /// <param name="dataTable"></param> /// <returns></returns> public static List<TSource> ToList<TSource>(this DataTable dataTable) where TSource : new() { var dataList = new List<TSource>(); const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic; var objFieldNames = (from PropertyInfo aProp in typeof(TSource).GetProperties(flags) select new { Name = aProp.Name, Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType }).ToList(); var dataTblFieldNames = (from DataColumn aHeader in dataTable.Columns select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList(); var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList(); foreach (DataRow dataRow in dataTable.AsEnumerable().ToList()) { var aTSource = new TSource(); foreach (var aField in commonFields) { PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name); var value = (dataRow[aField.Name] == DBNull.Value) ? null : dataRow[aField.Name]; //if database field is nullable propertyInfos.SetValue(aTSource, value, null); } dataList.Add(aTSource); } return dataList; } }
测试数据源：
public class Student { public long Id { get; set; } public string Name { get; set; } public short Age { get; set; } public DateTime DateOfCreation { get; set; } public bool? IsActive { get; set; } } public class Teacher { public long Id { get; set; } public string Name { get; set; } public Nullable<int> DepartmentId { get; set; } } public class Data { public static List<Student> GetStudents() { var list = new List<Student> { new Student {Id = 1, Name = "Smith", Age = 18, DateOfCreation = DateTime.Now, IsActive = true}, new Student {Id = 2, Name = "Hook", Age = 16, DateOfCreation = DateTime.Now.AddDays(-1), IsActive = true}, new Student {Id = 3, Name = "Jhon", Age = 15, DateOfCreation = DateTime.Now.AddDays(-2), IsActive = true}, new Student {Id = 4, Name = "Alan", Age = 21, DateOfCreation = DateTime.Now.AddDays(-3), IsActive = true} }; return list; } public static List<Teacher> GetTeachers() { var list = new List<Teacher> { new Teacher {Id = 1, Name = "Smith", DepartmentId = 18 }, new Teacher {Id = 2, Name = "Hook", DepartmentId = 16 }, new Teacher {Id = 3, Name = "Jhon", DepartmentId = 15 }, new Teacher {Id = 4, Name = "Alan", DepartmentId = 21 } }; return list; } public static DataTable DbNullInt() { DataTable table = new DataTable(); table.Columns.Add("Id", typeof(long)); table.Columns.Add("Name", typeof(string)); DataColumn column; column = new DataColumn("DepartmentId", System.Type.GetType("System.Int32")); column.AllowDBNull = true; table.Columns.Add(column); table.Rows.Add(1, "Smith", DBNull.Value); table.Rows.Add(2, "Hook", 1); return table; } }
测试：
List<Student> students = Data.GetStudents(); /*List to DataTable conversion*/ DataTable studentTbl = students.ToDataTable(); /*DataTable to List conversion*/ List<Student> newStudents = studentTbl.ToList<Student>();//ExtensionUtility.ToList<Student>(newStudents); this.dataGridView1.DataSource = newStudents; /*List to DataTable conversion*/ DataTable teacherTbl = Data.DbNullInt(); /*DataTable to List conversion*/ List<Teacher> newTeachers = teacherTbl.ToList<Teacher>(); this.dataGridView2.DataSource = newTeachers;
