Datatable to List
public static List<T> ToList<T>(this DataTable table) where T : class, new() { try { List<T> list = new List<T>(); foreach (var row in table.AsEnumerable()) { T obj = new T(); foreach (var prop in obj.GetType().GetProperties()) { try { PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name); propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null); } catch { continue; } } list.Add(obj); } return list; } catch { return null; } }Example:
var myList = dt.ToList();
Description
Datatable to List
Details
- Author: Keyur Panchal
- Submitted on: 8/11/2015 9:14:38 AM
- Language: C#
- Type: datatavle, List
- Views: 2810
Double click on the code to select all.