Filter out the rows in Datatable based on conditions

[Konda_Sai_Charan_Goud]

Hi, I have used a linq query to filter the rows in the Datatable.

Can someone help me how to get the remaining rows after filtering without using filter Datatable activity.

Thanks in Advance!!!

[lakshman (Ganta lakshman)]

@Konda_Sai_Charan_Goud

Try below expression.

dtRemaining = dtInput.AsEnumerable().Except(dtFiltered.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

Here, dtInput holds your Input DataTable and dtFiltered holds filter data from input.