.NET – Convert Generic Collection to DataTable

by

Then presumably you’ll need to lift them to the non-nullable form, using Nullable.GetUnderlyingType, and perhaps change a few null values to DbNull.Value…

Change the assignment to be:

row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;

and when adding the columns to be:

table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(
            prop.PropertyType) ?? prop.PropertyType);

And it works. (?? is the null-coalescing operator; it uses the first operand if it is non-null, else the second operand is evaluated and used)

More Related Contents:

  1. iterating through item of array of generic collections
  2. Convert generic List/Enumerable to DataTable?
  3. How do you convert a DataTable into a generic list?
  4. How to create List of open generic type of class?
  5. What is the best way to clone/deep copy a .NET generic Dictionary?
  6. Nullable type issue with ?: Conditional Operator
  7. How do I override List’s Add method in C#?
  8. Convert DataTable to generic List?
  9. Accessing a property of derived class from the base class in C#
  10. What is ‘1 in Collection type Name
  11. Returning ‘IList’ vs ‘ICollection’ vs ‘Collection’
  12. C# – Get the item type for a generic list
  13. What’s Wrong with an ArrayList?
  14. Correct way to check if a type is Nullable [duplicate]
  15. Convert DataTable to List
  16. Convert DataTable to Generic List in C#
  17. Convert List to List
  18. How to compare 2 dataTables
  19. Calling a generic method with a dynamic type [duplicate]
  20. Collection of generic types
  21. Is there a C# generic constraint for “real number” types? [duplicate]
  22. Why does IEnumerator inherit from IDisposable while the non-generic IEnumerator does not?
  23. Generic methods and method overloading
  24. Get Cell Value from a DataTable in C#
  25. Can I have a variable number of generic parameters?
  26. What is the equivalent of Java wildcards in C# generics
  27. Overload resolution issue for generic method with constraints
  28. How to convert c# generic list to json using json.net?
  29. Build c# Generic Type definition at runtime
  30. Initializing a Generic variable from a C# Type Variable

Leave a Comment