I'm trying to run a DISTINCT query to return a unique listing from my datatable...
I've tried putting .Distinct after the Compound_Block_Record, as another line on the order of From & Order... no go...
What am I doing wrong?
Thanks!
VB.NET:
Dim Compound_Blocks_Table_Query = From Compound_Block_Record In Compound_Blocks_Table.AsEnumerable Select Compound_Block_Record
Order By Compound_Block_Record.Field(Of String)("Compound.Block")
I've tried putting .Distinct after the Compound_Block_Record, as another line on the order of From & Order... no go...
What am I doing wrong?
Thanks!