Unique values from column in DataTable (source = xml)

[Fred]

Hi all,

I have a DataTable that is being filled with data from an xml file. Now
I need to get an array of strings from that DataTable that returns all
the unique values in a certain column (column name would be 'project'
and will at max contain 30 different projects). What would be the best
way to do this? Using a RowFilter and then pass the results into an
array if possible? I'm a bit stuck on how to do this the best way.

Thanks in advance,
Frederik

[Nicholas Paldino [.NET/C# MVP]]

Fred,

The best way to do this would be to enumerate through all of the rows in
the table, and then get the unique values yourself. The DataTable/DataView
doesn't have anything really which helps in this regards.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Fred" <fr********@gmail.com> wrote in message
news:11**********************@y43g2000cwc.googlegr oups.com...

Hi all,

I have a DataTable that is being filled with data from an xml file. Now
I need to get an array of strings from that DataTable that returns all
the unique values in a certain column (column name would be 'project'
and will at max contain 30 different projects). What would be the best
way to do this? Using a RowFilter and then pass the results into an
array if possible? I'm a bit stuck on how to do this the best way.

Thanks in advance,
Frederik