I usually use the following SQL statement coupled with a reader to populate an ASP.net DropDownList. In my latest solution I am trying to read the same items using a filter.
I'm not quite sure how to use Distinct or create get unique items from the following code
How would I adjust the following line marked XXXX ?
xSQLTable_Accounts.DefaultView.RowFilter = "[Segment 1 Desc]=*" 'XXXX
For i As Integer = 0 To xSQLTable_Accounts.DefaultView.Count - 1
.Add(xSQLTable_Accounts.DefaultView.Item(i).Item("Segment 1 Desc"))