DataView RowFilter - How to select distinct

[VBCrazyCoder]

Is it possible to select distinct in the rowfilter method?

I have something like:

'Create a data view so we can get each items name
        Dim dvwItemNames As New DataView(dtlItems)
        dvwItemNames.RowFilter() = "SELECT DISTINCT Name"

This gives me a syntax error exception. I tried just "Distinct Name" but this had the same result. "Name" is the column name.

Any ideas? I would rather do it this way then looping through the entire table and putting the name in an array list or something.

Thanks.