Efficient DataTable Group By

by

You may use Linq.

var result = from row in dt.AsEnumerable()
              group row by row.Field<int>("TeamID") into grp
               select new
                 {
                 TeamID = grp.Key,
                  MemberCount = grp.Count()
                  };
 foreach (var t in result)
     Console.WriteLine(t.TeamID + " " + t.MemberCount);

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. Read SQL Table into C# DataTable
  3. How I can filter a Datatable?
  4. Export DataTable to Excel File
  5. How to calculate the sum of the datatable column in asp.net?
  6. Datatable to html Table
  7. How do I loop through rows with a data reader in C#?
  8. How to convert DataTable to class Object?
  9. How to use __doPostBack()
  10. Can’t get Czech characters while generating a PDF
  11. Export DataTable to Excel with EPPlus
  12. How to check a input IP fall in a specific IP range
  13. What is the difference between PreserveReferencesHandling and ReferenceLoopHandling in Json.Net?
  14. Proper JSON serialization in MVC 4
  15. Foreach loop, determine which is the last iteration of the loop
  16. Dynamic MySQL database connection for Entity Framework 6
  17. Create thumbnail image
  18. Encrypt cookies in ASP.NET
  19. How to recognize if a string contains unicode chars?
  20. Thread safety for DataTable
  21. Find all child controls of specific type using Enumerable.OfType() or LINQ
  22. IIS Express Immediately shutting-down running site after stopping web application
  23. ASP.Net Core MVC – Client-side validation for custom attribute
  24. Opening password-protected pdf file with iTextSharp
  25. Comparing Object properties using reflection
  26. How to route EVERYTHING other than Web API to /index.html
  27. Document.Ready() is not working after PostBack
  28. How to add config transformations for a custom config file in Visual Studio?
  29. Sort two Lists together as one?
  30. Getting system Timezones in different languages

Leave a Comment