From the question it appears that all rows from
datatable
, which do not contain
JOB
in
stauscode
column are required to be filtered out, as the same
datatable
is used in the inner query. If that is the case, then I think the following query can be used.
var filteredRows = from n in datatable.AsEnumerable()
where !n.Field<string>("stauscode").Contains("JOB")
select n;
If the result is required as a
DataTable
then
var filteredTable = (from n in datatable.AsEnumerable()
where !n.Field<string>("stauscode").Contains("JOB")
select n).CopyToDataTable();