Compare two DataTables to determine rows in one but not the other

by

Assuming you have an ID column which is of an appropriate type (i.e. gives a hashcode and implements equality) – string in this example, which is slightly pseudocode because I’m not that familiar with DataTables and don’t have time to look it all up just now 🙂

IEnumerable<string> idsInA = tableA.AsEnumerable().Select(row => (string)row["ID"]);
IEnumerable<string> idsInB = tableB.AsEnumerable().Select(row => (string)row["ID"]);
IEnumerable<string> bNotA = idsInB.Except(idsInA);

More Related Contents:

  1. Convert generic List/Enumerable to DataTable?
  2. How to read a CSV file into a .NET Datatable
  3. Convert JSON to DataTable
  4. Inner join of DataTables in C#
  5. How To Change DataType of a DataColumn in a DataTable?
  6. Best way to remove duplicate entries from a data table
  7. How I can filter a Datatable?
  8. How to select min and max values of a column in a datatable?
  9. Export DataTable to Excel File
  10. Convert DataTable to CSV stream
  11. How to create a DataTable in C# and how to add rows?
  12. Convert DataTable to generic List?
  13. Merge 2 DataTables and store in a new one
  14. Creating a SQL Server table from a C# datatable
  15. DataTable, How to conditionally delete rows
  16. Convert DataTable to IEnumerable
  17. Data is visible in DataSet visualizer but does not show in a DataGrid
  18. Best way to check if a Data Table has a null value in it
  19. Datatable to html Table
  20. Best Practice: Convert LINQ Query result to a DataTable without looping
  21. Get Cell Value from a DataTable in C#
  22. How to change DataTable columns order
  23. How do I loop through rows with a data reader in C#?
  24. Convert DataTable to List
  25. Print Contents Of A DataTable
  26. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  27. How to Edit a row in the datatable
  28. How can I convert a DataTable into a Dynamic object?
  29. ComboBox.ValueMember and DisplayMember
  30. Is it possible to format a date column of a datatable?

Leave a Comment