The fact your two Tables are different in structure
makes this potentially
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"
: 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 :)