Basically what I want to know is if it is possible to query a dataset?

I understand that you can filter a dataset by using a dataview , but what I need to do is take all distinct values from a particular row and display them. So what I need to do is perform a query similar to this on the data in the dataset..

"SELECT DISTINCT row FROM table"

I cant query the database directly because the information being stored in the dataset does not currently exist in the database.

Anyone know if this can be done? or have any insight on to make this possible?