Distinct Sql??

[perspolis]

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

 

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

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.