Using Reflection to create a DataTable from a Class?

by

Building up on all the previous answers, here is a version that creates a DataTable from any collection:

public static DataTable CreateDataTable<T>(IEnumerable<T> list)
{
    Type type = typeof(T);
    var properties = type.GetProperties();      
    
    DataTable dataTable = new DataTable();
    dataTable.TableName = typeof(T).FullName;
    foreach (PropertyInfo info in properties)
    {
        dataTable.Columns.Add(new DataColumn(info.Name, Nullable.GetUnderlyingType(info.PropertyType) ?? info.PropertyType));
    }
    
    foreach (T entity in list)
    {
        object[] values = new object[properties.Length];
        for (int i = 0; i < properties.Length; i++)
        {
            values[i] = properties[i].GetValue(entity);
        }
        
        dataTable.Rows.Add(values);
    }
    
    return dataTable;
}

More Related Contents:

  1. Why not inherit from List?
  2. How to get the list of properties of a class?
  3. How do I get the path of the assembly the code is in?
  4. Set object property using reflection
  5. How to create a new object instance from a Type
  6. How do I use reflection to invoke a private method?
  7. Correct Way to Load Assembly, Find Class and Call Run() Method
  8. Find a private field with Reflection?
  9. How costly is .NET reflection?
  10. How to Load an Assembly to AppDomain with all references recursively?
  11. How can I get all classes within a namespace?
  12. How to get a list of properties with a given attribute?
  13. Get all derived types of a type
  14. Use reflection to invoke an overridden base method
  15. Get a generic method without using GetMethods
  16. AddEventHandler using reflection
  17. Resolve Type from Class Name in a Different Assembly
  18. Discovering derived types using reflection
  19. How do I create a generic class from a string in C#? [duplicate]
  20. Determine if a type is static
  21. Is there a much better way to create deep and shallow clones in C#?
  22. Get member to which attribute was applied from inside attribute constructor?
  23. Can you explain Liskov Substitution Principle with a good C# example? [closed]
  24. Using GetProperties() with BindingFlags.DeclaredOnly in .NET Reflection
  25. Finding property differences between two C# objects
  26. How Can I add properties to a class on runtime in C#?
  27. Look if a method is called inside a method using reflection
  28. Can I get parameter names/values procedurally from the currently executing function?
  29. IsAssignableFrom() returns false when it should return true
  30. Why do both the abstract class and interface exist in C#?

Leave a Comment