I have the linq query below which returns a bunch of results. Now I want to narrow down that query more. There are certain columns the user can choose to group by and I need to narrow it down until I have looped through all the columns that the user chose to group by.
I am not real sure how to explain it but basically with qry that gets returned below I need to be able to do this:
qry=qry.select("A column from one of the tables" = "A specified value")
the number of times and names of the columns that it narrows by can change all the time.
Dim qry = From m In dsMaterial.tbMaterial Join s In dsMaterial.tbMatInventory On m.MaterialKey Equals s.MaterialKey