My latest puzzle has been how to bind a listbox to distinct records in a DataTable within a Dataset. As there is no method of selecting distinct records from a view, Microsoft's solution is to Implement a DataSet SELECT DISTINCT Helper Class in Visual Basic .NET. I've used this approach, and it works, but I can't help but feel it's not the most efficient way.
Anyone have any other ideas or solutions to this?