LINQ query on a DataTable

by

You can’t query against the DataTable‘s Rows collection, since DataRowCollection doesn’t implement IEnumerable<T>. You need to use the AsEnumerable() extension for DataTable. Like so:

var results = from myRow in myDataTable.AsEnumerable()
where myRow.Field<int>("RowNo") == 1
select myRow;

And as @Keith says, you’ll need to add a reference to System.Data.DataSetExtensions

AsEnumerable() returns IEnumerable<DataRow>. If you need to convert IEnumerable<DataRow> to a DataTable, use the CopyToDataTable() extension.

Below is query with Lambda Expression,

var result = myDataTable
    .AsEnumerable()
    .Where(myRow => myRow.Field<int>("RowNo") == 1);

Related Contents:

  1. Get all column names of a DataTable into string array using (LINQ/Predicate)
  2. Create a dictionary on a list with grouping
  3. Convert DataRowCollection to IEnumerable
  4. LINQ – Find all items in one list that aren’t in another list
  5. How to convert DataTable to class Object?
  6. LINQ’s Distinct() on a particular property
  7. Group By Multiple Columns
  8. When to use .First and when to use .FirstOrDefault with LINQ?
  9. Concat all strings inside a List using LINQ
  10. Update all objects in a collection using LINQ
  11. How to read a CSV file into a .NET Datatable
  12. Select a Dictionary with LINQ
  13. How to check if IEnumerable is null or empty?
  14. LINQ – Left Join, Group By, and Count
  15. Linq: GroupBy, Sum and Count
  16. How to take all but the last element in a sequence using LINQ?
  17. Adding List.add() another list
  18. Filling a DataSet or a DataTable from a LINQ query result set
  19. Sequence contains more than one element
  20. Checking if a list is empty with LINQ
  21. What is the purpose of AsQueryable()?
  22. Paging with LINQ for objects
  23. C# – code to order by a property using the property name as a string [duplicate]
  24. Best way to check if a Data Table has a null value in it
  25. Searching a tree using LINQ
  26. Can I split an IEnumerable into two by a boolean criteria without two queries?
  27. best way to clear contents of .NET’s StringBuilder
  28. Why is LINQ .Where(predicate).First() faster than .First(predicate)?
  29. How do you determine if two HashSets are equal (by value, not by reference)?
  30. Dictionary.FirstOrDefault() how to determine if a result was found
  31. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  32. Convert SQL to Linq left join with null
  33. What are Expression Trees, how do you use them, and why would you use them?
  34. System.Data.Linq.ChangeConflictException: Row not found or changed
  35. LINQ – selecting second item in IEnumerable
  36. Handling ‘Sequence has no elements’ Exception [duplicate]
  37. C# Linq Where(expression).FirstorDefault() vs .FirstOrDefault(expression)
  38. IEnumerable to string delimited with commas?
  39. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  40. Difference between Select and Where in Entity Framework
  41. Get Absolute URL from Relative path (refactored method)
  42. Get Cell Value from a DataTable in C#
  43. Is the Linq Count() faster or slower than List.Count or Array.Length?
  44. How to include() nested child entity in linq
  45. Intersect LINQ query
  46. LINQ – Does the Where expression return new instance or reference to object instance
  47. Custom sort logic in OrderBy using LINQ
  48. Guid == null should not be allowed by the compiler
  49. How do I update a single item in an ObservableCollection class?
  50. Best way to remove duplicate entries from a data table

Leave a Comment