Datatable select with multiple conditions

by

Yes, the DataTable.Select method supports boolean operators in the same way that you would use them in a “real” SQL statement:

DataRow[] results = table.Select("A = 'foo' AND B = 'bar' AND C = 'baz'");

See DataColumn.Expression in MSDN for the syntax supported by DataTable’s Select method.

More Related Contents:

  1. How to select distinct rows in a datatable and store into an array
  2. How to select min and max values of a column in a datatable?
  3. How to read a CSV file into a .NET Datatable
  4. Convert JSON to DataTable
  5. How do you convert a DataTable into a generic list?
  6. Inner join of DataTables in C#
  7. How To Change DataType of a DataColumn in a DataTable?
  8. Export DataTable to Excel with EPPlus
  9. How to get values from IGrouping
  10. How to compare 2 dataTables
  11. C# – Fill a combo box with a DataTable
  12. How to create a DataTable in C# and how to add rows?
  13. Check if value exists in dataTable?
  14. How to calculate the sum of the datatable column in asp.net?
  15. Simple way to copy or clone a DataRow?
  16. How to fill a datatable with List [duplicate]
  17. Thread safety for DataTable
  18. DataTable to JSON [duplicate]
  19. DataTable equivalent in Java [duplicate]
  20. Convert DataTable to JSON with key per row
  21. Copy rows from one Datatable to another DataTable?
  22. Get Cell Value from a DataTable in C#
  23. How do I create a DataTable, then add rows to it?
  24. Returning DataTables in WCF/.NET
  25. How do I use SELECT GROUP BY in DataTable.Select(Expression)?
  26. How to convert DataTable to class Object?
  27. Replacing a DataReader with a DataTable
  28. How can I convert a DataTable to an XML file in C#?
  29. How do you Sort a DataTable given column and direction?
  30. Convert DataTable to Generic List in C#

Leave a Comment