How do I use SELECT GROUP BY in DataTable.Select(Expression)?

by

DataTable‘s Select method only supports simple filtering expressions like {field} = {value}. It does not support complex expressions, let alone SQL/Linq statements.

You can, however, use Linq extension methods to extract a collection of DataRows then create a new DataTable.

dt = dt.AsEnumerable()
       .GroupBy(r => new {Col1 = r["Col1"], Col2 = r["Col2"]})
       .Select(g => g.OrderBy(r => r["PK"]).First())
       .CopyToDataTable();

More Related Contents:

  1. ERROR: Cannot convert method group ‘CopyToDataTable’ to non-delegate type ‘System.Data.DataTable’. Did you intend to invoke the method?
  2. How to use Select method of DataTable
  3. Remove duplicates from a List in C#
  4. Convert IEnumerable to DataTable
  5. Sorting rows in a data table
  6. Best way to remove duplicate entries from a data table
  7. How can I turn a DataTable to a CSV?
  8. How I can filter a Datatable?
  9. How to bind DataTable to Datagrid
  10. Efficient DataTable Group By
  11. Export DataTable to Excel File
  12. Convert DataTable to CSV stream
  13. How to merge 2 List and removing duplicate values from it in C#
  14. Does Distinct() method keep original ordering of sequence intact?
  15. Convert DataTable to generic List?
  16. Merge 2 DataTables and store in a new one
  17. Creating a SQL Server table from a C# datatable
  18. DataTable, How to conditionally delete rows
  19. Datatable vs Dataset
  20. Convert DataTable to IEnumerable
  21. Data is visible in DataSet visualizer but does not show in a DataGrid
  22. Datatable to html Table
  23. Best Practice: Convert LINQ Query result to a DataTable without looping
  24. How to change DataTable columns order
  25. How do I loop through rows with a data reader in C#?
  26. How to Read text file to DataTable [closed]
  27. How to convert DataTable to class Object?
  28. How can I convert a DataTable to an XML file in C#?
  29. Is it possible to format a date column of a datatable?
  30. How do you Sort a DataTable given column and direction?

Leave a Comment