Distinct rows from a dataset?

[Scott Meddows]

Can I select DISTINCT rows by using Dataset.DefaultView.RowFilter = "Distinct Col1, Col2"

 

[Marina]

No built in way. You will either have to do it in your sql query, or roll
your own mechanism. The dataset is really not a very good replacement for a
database - it has severe limitations on what it can do for you.

 

[Scott Meddows]

darn

Thanks for the quick response!

No built in way. You will either have to do it in your sql query, or roll
your own mechanism. The dataset is really not a very good replacement for a
database - it has severe limitations on what it can do for you.

 

[Guest]

Can I select DISTINCT rows by using Dataset.DefaultView.RowFilter = "Distinct Col1, Col2"

User submitted from AEWNET (http://www.aewnet.com/)

 

[Miha Markic [MVP C#]]

No.

 

[Sahil Malik]

As Miha said, NO you can't .. in that way .. but you could write a function
to do that atleast on a dataset.

Here is how --
http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/26/39040.aspx

Also Frans Bouma mentioned a really good point in comments.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

 

[Cor Ligthert]

Guest,

When you are using VBNet something I once made as sample,

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/msg/f88449bba5e5e1d0

I hope this helps?

Cor

 

[Miha Markic [MVP C#]]

Few other links

HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326176

HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual Basic
..NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;325684