How to get rid of duplicates in a dataset?

[Guest]

I have a dataset that I've filled with the data I want. There are duplicate
records in the dataset. Does anyone know a way to get rid of the duplicates?
I'm sure I can do it with a bunch of code, but I was wondering if someone
knew a cool trick or if something is built into .net to do that.

Thanks.

 

[John Timney \(ASP.NET MVP\)]

If its filled via SQL just use SELECT DISTINCT in your in your statement

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director