Try this
1.I would get data rows that are not present in the second file but present in first
From row in Dt1.Select() where (from row1 in Dt2.Select() where String.join(“,”,row1.ItemArray)=String.join(“,”,row.ItemArray)).ToList.Count=0
select row;
2.I would get data rows that are present in second file but not present in the first.
From row in Dt2.Select() where (from row1 in Dt1.Select() where String.join(“,”,row1.ItemArray)=String.join(“,”,row.ItemArray)).ToList.Count=0
select row;
thanks for the quick response.
I have tried something like this
(From x In dataTable_CompareOpencoDV6.AsEnumerable() where Not (From a In dataTable_CompareOpencoDV6.AsEnumerable() Join b In dataTable_CompareActuarial_DV6.AsEnumerable() On a(column_1_OpencoCompare).ToString Equals b(column_1_OpencoCompare).ToString And a(column_2_OpencoCompare).ToString() Equals b(column_2_OpencoCompare).ToString And a(column_3_OpencoCompare).ToString equals b(column_3_OpencoCompare).ToString and a(column_4_OpencoCompare).ToString equals b(column_4_OpencoCompare).ToString and a(column_5_OpencoCompare).ToString equals b(column_5_OpencoCompare).ToString and a(column_6_OpencoCompare).ToString equals b(column_6_OpencoCompare).ToString and a(column_7_OpencoCompare).ToString() equals b(column_7_OpencoCompare).ToString and a(column_8_OpencoCompare).ToString equals b(column_8_OpencoCompare).ToString and a(column_9_OpencoCompare).ToString equals b(column_9_OpencoCompare).ToString and a(column_10_OpencoCompare).ToString equals b(column_10_OpencoCompare).ToString and a(column_11_OpencoCompare).ToString equals b(column_11_OpencoCompare).ToString and a(column_12_OpencoCompare).ToString equals b(column_12_OpencoCompare).ToString and a(column_13_OpencoCompare).ToString equals b(column_13_OpencoCompare).ToString and a(column_14_OpencoCompare).ToString equals b(column_14_OpencoCompare).ToString and a(column_15_OpencoCompare).ToString equals b(column_15_OpencoCompare).ToString and a(column_16_OpencoCompare).ToString equals b(column_16_OpencoCompare).ToString and a(column_17_OpencoCompare).ToString equals b(column_17_OpencoCompare).ToString select a).Contains(x) select x).CopyToDataTable()…
When there is only one row in both the excels an exception is thrown saying - The source does not contain any data rows.
This might be because there will not be in any data which is fetched after compassion.
How can we check whether this comparison yields any data rows because if that can be found then we can copy those data rows in a data table in the next step instead of doing it in the same step.
I tried using variable of type datarows to copy the data rows of the result but it is giving me an error saying you cannot convert ienumurable to 1 dimension data row array
