Datatable Compare for Checking Rows Exist and a Condition is true for further process

[Shiva_Nikhil]

@Prateek_Gulab_Pathak

do you want to check one by one for every row or you want to check all the rows at once

try this once

Check Dt1 Column1 all Values Exist In the Dt2 column 1

@Prateek_Gulab_Pathak You can try this Array1=dt1.AsEnumerable.select(function(x) x(0).tostring).toarray Array2= dt2.AsEnumerable.select(function(x) x(0).tostring).toarray Booloutput= Array1.Except(Array2).Count() = 0 If booloutput gives true or false

for comparision use the below query

d1.aseumerable.where(function(x) dt2.asenumerable.any(function(r) cdbl(x("Quantity).tostring)<cdbl(r(“Quantity”).tostring))).copytodatatable