How to fill a datatable with List [duplicate]

by

Just in case you have a nullable property in your class object:

private static DataTable ConvertToDatatable<T>(List<T> data)
{
    PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T));
    DataTable table = new DataTable();
    for (int i = 0; i < props.Count; i++)
    {
        PropertyDescriptor prop = props[i];
        if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
            table.Columns.Add(prop.Name, prop.PropertyType.GetGenericArguments()[0]); 
        else
            table.Columns.Add(prop.Name, prop.PropertyType);
    }

    object[] values = new object[props.Count];
    foreach (T item in data)
    {
        for (int i = 0; i < values.Length; i++)
        {
            values[i] = props[i].GetValue(item);
        }
        table.Rows.Add(values);
    }
    return table;
 }

More Related Contents:

  1. How to use Select method of DataTable
  2. How to create a DataTable in C# and how to add rows?
  3. Creating a SQL Server table from a C# datatable
  4. Thread safety for DataTable
  5. DataTable equivalent in Java [duplicate]
  6. How do I create a DataTable, then add rows to it?
  7. How do you Sort a DataTable given column and direction?
  8. Call a stored procedure with parameter in c#
  9. Calling stored procedure with return value
  10. Sorting rows in a data table
  11. OleDbCommand parameters order and priority
  12. Read SQL Table into C# DataTable
  13. Invalid attempt to read when no data is present
  14. How to convert datatable to json string using json.net?
  15. Difference with Parameters.Add and Parameters.AddWithValue
  16. Efficient DataTable Group By
  17. How to save image in database using C# [closed]
  18. DbArithmeticExpression arguments must have a numeric common type
  19. Connection timeout for SQL server
  20. How to fill Dataset with multiple tables?
  21. How DataReader works?
  22. Copy rows from one Datatable to another DataTable?
  23. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  24. Enabling Foreign key constraints in SQLite
  25. Datatable select with multiple conditions
  26. DataTable internal index is corrupted
  27. How do I connect to a SQL database from C#?
  28. ComboBox.ValueMember and DisplayMember
  29. How can I Pass a Table Name to SqlCommand?
  30. Why can’t I do foreach (var Item in DataTable.Rows)?

Leave a Comment