DataView/DataTable DISTINCT view

[Guest]

Hi,

I use a DataView to display a State field. But some rows have the same state
like 'OH'. How can I just display only one of them like SQL's DISTINCT? Can I
use .rowfilter? How?
I don't have to use DataView. If DataTable can do it, it's ok too.

Thanks in advance.

Li

 

[Cor Ligthert]

Li,

You cannot you would have to make your own new datatable.

Have a look in this message there is a sample from me how to do it.

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/msg/97ecb0034de41cb4?hl=en

I hope this helps a little bit?

Cor

 

[Guest]

Hi, Cor:

Thanks a lot!

Li