Select Distince Row Filter for dataview

microsoft.public.dotnet.framework.adonet

1 May 2006 9:19 PM

G Hustis

Is there a way to filter the rows of a Data View using the "Select Distinct"
SQL statement? If so how do i use it? Thanks.
Gary

1 May 2006 10:03 PM

Miha Markic [MVP C#]

No. It can't - how would it work? DataView always shows entire rows, now if
you go distinct which row would you show?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"G Hustis" <GHus***@discussions.microsoft.com> wrote in message
news:8C62594E-B491-4C86-AC64-1F9854C4DDAD@microsoft.com...
> Is there a way to filter the rows of a Data View using the "Select
> Distinct"
> SQL statement? If so how do i use it? Thanks.
> Gary