Datatables, Dataviews and distincts! (ASP.Net/VB)

Question

Has anyone got anything better than creating a copy of the original datatable and then looping through it to create a distinct view ?

From what I've read and attempted, the dataview doesn't support distinct (currently system is in Studio.NET 2003 - looking to move to 2005 shortly but 2008 isn't on the radar - so if newer versions do, please accept my ineptitude as a sign of old age!).

I know I could create another Oracle procedure to create the distinct version but I'm trying to keep my calls down as certain parts of the system are being pushed down the whole new world of hurt that is known as PDA/Mobile route - so it's possible I may lose connection anyway and I know I can save stuff out to XML, etc - but one step at a time.

Any thoughts/pointers gratefully accepted.

Answer 1

I'm pretty sure this article on msdn should do the trick for you. Has a complete code sample on how to create a distinct set of data from a datatable.

Answer 2

Thanks for that lomaxx - searched quite a bit on this and never found such a succinct answer.

Answer 3

that is a perfect answer to the question I would up vote the answer if I could but I am not up to 15 rep, yet!

"you're only 15, you dont have a rep yet! parents just dont understand." Fresh Prince and Jazzy Jeff. LOL

Answer 4

You can also directly use to create a new dataview object from an existing datatable dt

DataView dv = new DataView(dt, filter, sort, DataViewRowState.CurrentRows);