use of DISTINCT in DataTable.Select Method

[M.M Ansari]

Hi all

is it valid to use DISTINCT operator in select method of datatable? if yes
then what is syntax?

thanks in advance


Ansari

 

[Herfried K. Wagner [MVP]]

is it valid to use DISTINCT operator in select method of datatable? if yes
then what is syntax?

Notice that this is a Windows Forms group. For "data" related
questions, have a look here:

<URL:
Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>

 

[Guest]

I don't believe distinct is supported. The only reserved words used in the
expression parser are:

And, Or, True, False, Is, In, Like, Not, Null, Between, Child, and Parent.

There are a number of functions handled as well (Abs, Acos, Ascii, Avg,
etc...) but none of these are of any use either.

I could be wrong. That was just a quick scan. My guess is you'll have to
code it by hand.

Pete

 

[Guest]

And right after I replied, I came across this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;326176

Pete