Ok so have looked into the DataView and read that its not going to do what I want as I already have a DT populated but have a situation where I now need to filter it with a DISTINCT query and WHERE clause so using a dataview wont work. I dont want to requery the db just for this since its already in memory.

Ideas?

Thanks