I have an array “MaterialArray” which has some material numbers inside it. And I have datatable DT.
This DT has a column named “Material Number” and there are material numbers written. I want to remove the rows where the “Material Number” column contains a value which is present in the Array.
After the execution of that code I want a dt:
so the rows which material array has the values are removed.
I wrote this code but It is not working properly.
(From r In DT.AsEnumerable
Where Not MaterialArray.Any(Function (x) r(“Material Number”).toString.toUpper.Contains(x.ToUpper))