Select distinct ?

[UJ]

I have set a dataview on a datatable and I want to know the distinct value
for one of the columns in the dataview.

Is there an easy way to do this?

 

[Guest]

This may not be the best way to do it (as it really depends on the context),
but you can try this:

MyDataTable.Select("MyExpression = MyValue")(0).Items("MyColumnName").

In english: select an array of DataRows from the datatable based on some
expression - grab the first one in the array, and pull out the value in the
specified column.

 

[Cor Ligthert [MVP]]

UJ,

In version 2.0 this is standard now.
http://msdn2.microsoft.com/en-us/library/wec2b2e6.aspx

In version 1.x you have to create that.
http://www.vb-tips.com/dbPages.aspx?ID=dcad9a66-1366-4d61-8d32-1a580eb893b2

I hope this helps,

Cor

 

[UJ]

Cool. Thanks - that worked great - and was easy also......