Avatar of Dnx_7
Flag for Belgium

asked on 

LINQ - How to make a distinct on multiple datarow field?

Hi experts

i have this LINQ

Dim searchTrigger As IEnumerable(Of DataRow) = From r As DataRow In Me._dtTrigger.AsEnumerable _
                                                               Where r.Field(Of String)("BCEID").ToUpper Like searchBuilder.ToString _
                                                               Select r _

what i have is a datatable with 2 columns, i have to select the whole datarow but i have to filter (distinct) result on one specific field...

can you help me to achieve this?

Kind regards
.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon