If I have a DataTable
userwidget, which has the following columns:
process_id, emp_num, widget_color
How to filter this
LINQ according to the following conditions:
emp_num = ...
process_id NOT IN (process)//process is an array of intgers
var filtered = (from row in tbl.AsEnumerable() where row.Field<int>("emp_num")==yourNum && !process.Contains(row.Field<int>("process_id")) select row).CopyToDataTable();