Distinct on a datatable

[balmerch]

I need to run this:

Select Distinct(Role) From Member

on a datatable I loaded from an XML file. How do I do this when I am not running the database on a sql server to run the statement on, I tried the filter property of the dataview but that is only for the statements in the WHERE clause of a sql statement.

Chris

[nemaroller]

Try this link (its in c#, but if you need the VB code, i translated it below)

http://www.mastercoder.net/viewtopic.php?t=44

Dim distinctVal As Integer = 0
Dim row As DataRow
For Each row in testDT
If distintVal != row("column")
newTable.AddRow(row)
distintVal = row("column")
End If
Next