Distinct Sql??

[perspolis]

Hi everybody
is it possible to use Distict sql in DataTable.or DataView..
for example dt.DefaultView. RowFilter="Dist inct Code";
??

[Nicholas Paldino [.NET/C# MVP]]

Re: Distinct Sql??

perspolis,

No, it is not. However, you can write a function to do this for you
easily. Basically, you would sort the table (through a data view) on the
distinct fields in the table. Then, cycling through the rows, you would
check to see when the values change among the fields you are getting
distinct values for. If it changes, then you store the set of values, and
move on.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard. caspershouse.co m

"perspolis" <rezarms@hotmai l.com> wrote in message
news:OLbZ500aFH A.2860@TK2MSFTN GP10.phx.gbl...[color=blue]
> Hi everybody
> is it possible to use Distict sql in DataTable.or DataView..
> for example dt.DefaultView. RowFilter="Dist inct Code";
> ??
>
>[/color]