I would like to do a select distinct on a fieldname in a
dataset. Is this possible using the DataTable.Select
Method?

If so do you have an example?

I can use the method to do things like this.... very
easily, but can't find a way to select distinct.

Dim dr As DataRow() = ds.Tables(0).Select("fieldname
= 'value' ")

Thanks

http://support.microsoft.com/default...en-us%3B325684
"doug" <(E-Mail Removed)> wrote in message
news:00d001c3c4f6$9e00b030$(E-Mail Removed)...
> I would like to do a select distinct on a fieldname in a
> dataset. Is this possible using the DataTable.Select
> Method?
>
> If so do you have an example?
>
> I can use the method to do things like this.... very
> easily, but can't find a way to select distinct.
>
> Dim dr As DataRow() = ds.Tables(0).Select("fieldname
> = 'value' ")
>
> Thanks
>