ExtensionMethod.NET Home of 876 C#, Visual Basic, F# and Javascript extension methods

DataTable to List

Datatable to List


public static DataTable ToDataTable<T>(this IList<T> data)
    PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T));
    DataTable table = new DataTable();
    foreach (PropertyDescriptor prop in properties)
        table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
    foreach (T item in data)
        DataRow row = table.NewRow();
        foreach (PropertyDescriptor prop in properties)
            row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
    return table;


var myList = dt.ToList();

Author: Keyur Panchal

Submitted on: 11 aug. 2015

Language: C#

Type: Keyur

Views: 4459