Can you query the tables in a dataset?

[Duncanm]

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?

[Edneeis]

Have you tried filtering through the use of the Select method of a table? That will return an array of DataRows that meet the filtered criteria.

[Duncanm]

Thanks for the reply , I hadn't looked at that function but it apears to do the same as creating a dataview. It doesn't seem to allow for the type of query I am trying.

What I am trying to do is take a field and only display unique values from that field. For example If I had the following data:

1 , 2, 2, 3, 3, 3, 4, 5

I would want to display only:

1 , 2, 3, 4, 5

Thats what the "SELECT DISTINCT" query or even a "GROUP BY query should accomplish..