I am currently trying to compare two DataTables, and add a row to a new DataTable if the row of DataTable A (
inputdata) column 1 contains the same value as DataTable B (
ReadOutput) column 1, and DataTable B (
ReadOutput) contains “Posting” in column 5. See the below screenshot:
I have the comparison code, but I cannot work out how to add the DataRow of DataTable A to a new DataTable.
row inside of the For Each Row is part of a DataTable so I cannot write it to a new DataTable, and
inputdata.Rows(CompareCount) is classed as an object. Does anybody have a method of adding a DataTable row to a new DataTable?
Thanks in advance