Convert List to Data Table c#

Code Snippets 4 U
DataTable ConvertToDataTable<T>(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;

             table.Rows.Add(row);

        }

        return table;

}

Leave a Reply

Your email address will not be published. Required fields are marked *

eighty one − = eighty