Merge 2 DataTables and store in a new one

by

The Merge method takes the values from the second table and merges them in with the first table, so the first will now hold the values from both.

If you want to preserve both of the original tables, you could copy the original first, then merge:

dtAll = dtOne.Copy();
dtAll.Merge(dtTwo);

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. Convert generic List/Enumerable to DataTable?
  3. How to read a CSV file into a .NET Datatable
  4. Convert JSON to DataTable
  5. Convert IEnumerable to DataTable
  6. Inner join of DataTables in C#
  7. How To Change DataType of a DataColumn in a DataTable?
  8. Best way to remove duplicate entries from a data table
  9. How I can filter a Datatable?
  10. How to select min and max values of a column in a datatable?
  11. Compare two DataTables to determine rows in one but not the other
  12. Export DataTable to Excel File
  13. Convert DataTable to CSV stream
  14. How to compare 2 dataTables
  15. How to create a DataTable in C# and how to add rows?
  16. Convert DataTable to generic List?
  17. Creating a SQL Server table from a C# datatable
  18. DataTable, How to conditionally delete rows
  19. Convert DataTable to IEnumerable
  20. Data is visible in DataSet visualizer but does not show in a DataGrid
  21. Best way to check if a Data Table has a null value in it
  22. Datatable to html Table
  23. Best Practice: Convert LINQ Query result to a DataTable without looping
  24. Get Cell Value from a DataTable in C#
  25. How to change DataTable columns order
  26. How do I loop through rows with a data reader in C#?
  27. How to convert DataTable to class Object?
  28. Replacing a DataReader with a DataTable
  29. How can I convert a DataTable to an XML file in C#?
  30. Convert DataTable to Generic List in C#

Leave a Comment