The fact your two Tables are
different in structure makes this
potentially more complex.
In any case, you are going to need to learn how to use 'RowFilter, and the 'Select method of 'DataTable: [
^]
DataRow[] XZValuesSelected = dt.Select("X = 0 AND Z = 4");
I now have an Array of Rows where those specified values match ... however I cannot directly compare that to a similarly selected Row from another DataTable
with a different structure !
Are the NAMES of the two columns
with the same values the SAME in each Table ? The INDEXES in the column collections
identical ?
"for example in the common two columns in table A there is code=x , Nature =y and in table B there is also code=x , Nature =y , so this record should be removed when I fetch the table A records"
By
remove: I assume you mean FILTER table A, not actually remove a ROW ?
You want to Filter out ALL instances of rows where the two columns have identical values, or ONLY rows with identical values you specify ?
Can't read your mind :)