LINQ join two DataTables

by

This will let you default to 0 if the row doesn’t exist in table2:

var result = from dataRows1 in table1.AsEnumerable()
             join dataRows2 in table2.AsEnumerable()
             on dataRows1.Field<string>("ID") equals dataRows2.Field<string>("ID") into lj
             from r in lj.DefaultIfEmpty()
             select dtResult.LoadDataRow(new object[]
             {
                dataRows1.Field<string>("ID"),
                dataRows1.Field<string>("name"),
                r == null ? 0 : r.Field<int>("stock")
              }, false);

MSDN source

More Related Contents:

  1. LEFT OUTER JOIN in LINQ
  2. Join/Where with LINQ and Lambda
  3. How to do joins in LINQ on multiple fields in single join
  4. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  5. How to perform Join between multiple tables in LINQ lambda
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. LINQ: combining join and group by
  8. Generic All Controls Method
  9. Select all columns after JOIN in LINQ
  10. Binding hierarchical xml to treeview
  11. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  12. Is it possible to perform joins across different databases using LINQ?
  13. How can I read, write, and modify the contents of a notepad (.txt) file, in Winform and WPF? [duplicate]
  14. Translucent circular Control with text
  15. How do I pass command-line arguments to a WinForms application?
  16. Detecting design mode from a Control’s constructor
  17. How do I get the title of the current active window using c#?
  18. Close a MessageBox after several seconds
  19. How to compare two rich text box contents and highlight the characters that are changed?
  20. How to hide TabPage from TabControl [duplicate]
  21. C# vertical label in a Windows Forms
  22. Is the Linq Count() faster or slower than List.Count or Array.Length?
  23. ComboBox.SelectedText doesn’t give me the SelectedText
  24. How to create a Button that can send keys to a conrol without losing focus – Virtual Keyboard
  25. String.IsNullOrWhiteSpace in LINQ Expression
  26. Getting value of selected item in list box as string
  27. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  28. How to compute the correct width of a digit in pixels?
  29. DataGridView Image for Button Column
  30. Winform – determine if mouse has left user control

Leave a Comment