Distinct on a DataSet.

[Ken Varn]

Is it possible somehow to get a DataView from a DataSet that can get distict
rows from the DataSet?


--
-----------------------------------
Ken Varn
Senior Software Engineer
Diebold Inc.

EmailID = varnk
Domain = Diebold.com
-----------------------------------

 

[Miha Markic [MVP C#]]

Hi Ken,

AFAIK no.
A good old foreach should do instead.

 

[Sahil Malik [MVP]]

In .NET 2.0 you can use DataView to get a DataTable that has distinct
results, and then you can form a DataView on it (albeit, this duplicates
data, unlike a dataview).

In .NET 1.1 you can however perform a Select distinct on a DataTable using
this code snippet here -
http://codebetter.com/blogs/sahil.malik/archive/2004/12/26/39040.aspx

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

 

[Cor Ligthert [MVP]]

Ken,

As Miha said a foreach can do it, have a look at this sample on our website.

http://www.windowsformsdatagridhelp.com/default.aspx?ID=dcad9a66-1366-4d61-8d32-1a580eb893b2

I hope this helps,

Cor