score:2

Accepted answer

create the first filter in a separate ienumerable, then use it to create both dataviews:

var filtered = dt.asenumerable()
                 .where(r => r.field<int>("id") < 1000);


dataview dv1 = filtered.asdataview();

dataview dv2 = filtered.where(r => r.field<string>("salary") > 50000)
                       .asdataview();

Related Query

More Query from same tag