Convert List to DataTable in C#

public 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;

    }
Reference: Muthukumar (http://nadarmuthukumar.blogspot.in) 
Hope you liked this post, also let me know your thoughts on the post through your valuable comment. 
Thank you.

0 comments:

Twitter Delicious Facebook Digg Stumbleupon Favorites More