Convert DataTable to List

by

The following does it in a single line:

dataTable.Rows.OfType<DataRow>()
    .Select(dr => dr.Field<MyType>(columnName)).ToList();

[Edit: Add a reference to System.Data.DataSetExtensions to your project if this does not compile]

More Related Contents:

  1. Convert DataTable to generic List?
  2. How do I use reflection to call a generic method?
  3. Pass An Instantiated System.Type as a Type Parameter for a Generic Class
  4. Convert generic List/Enumerable to DataTable?
  5. How to get the type of T from a member of a generic class or method
  6. How to read a CSV file into a .NET Datatable
  7. Passing arguments to C# generic new() of templated type
  8. What exactly is an “open generic type” in .NET? [duplicate]
  9. Generics in C#, using type of a variable as parameter [duplicate]
  10. Create instance of generic type whose constructor requires a parameter?
  11. A generic list of anonymous class
  12. Why must I provide explicitly generic parameter types While the compiler should infer the type?
  13. Func with out parameter
  14. How to select min and max values of a column in a datatable?
  15. How to compare 2 dataTables
  16. Why isn’t ArrayList marked [Obsolete]?
  17. Convert string to nullable type (int, double, etc…)
  18. How to initialize a List to a given size (as opposed to capacity)?
  19. Generic Type in constructor
  20. Collection of generic types
  21. Wildcard equivalent in C# generics
  22. DataTable equivalent in Java [duplicate]
  23. Best way to check if a Data Table has a null value in it
  24. Get Cell Value from a DataTable in C#
  25. Generics can’t infer second parameter? [duplicate]
  26. Can I have a variable number of generic parameters?
  27. Returning DataTables in WCF/.NET
  28. Which C# method overload is chosen?
  29. Are static members of a generic class tied to the specific instance?
  30. Why it is not possible to define generic indexers in .NET?

Leave a Comment