<div>
<br />

<pre><code class="code-1 nolinks" id="code-122245"><span>Dim searchTrigger  = (From r As DataRow In Me._dtTrigger.AsEnumerable _ Where r.Field(Of String)(&quot;BCEID&quot;).ToUpper Like searchBuilder.ToString Select r).Distinct()</span>
</code></pre>
</div>


<div>
woops<br />

<pre><code class="code-1 nolinks" id="code-122246"><span>Dim searchTrigger  = (From r As DataRow In Me._dtTrigger.AsEnumerable Where r(&quot;BCEID&quot;).ToUpper.contains(searchBuilder.ToString) Select r).Distinct()</span>
</code></pre>
</div>


<div>
doesn't work, your query is the same as mine... even the contains doesn't work like the &quot;Like&quot; Operator...<br />
<br />
regards
</div>


<div>
sorry, you are correct<br />

<pre><code class="code-1 nolinks" id="code-122297"><span>Dim searchTrigger  = (From r As DataRow In Me._dtTrigger.AsEnumerable Where r(&quot;BCEID&quot;).ToUpper.Equals(searchBuilder.ToString.ToUpper) Select r).Distinct()</span>
</code></pre>
</div>


<div>
Hi, <br />
<br />
the problem is not on the Like operator...<br />
the like works perfectly but i have to distinct result on field<br />
<br />
because this linq is on &quot;textChanged&quot; event <br />
suppose the user type &quot;B&quot;<br />
<br />
i have to search all the &quot;BCEID&quot; like &quot;B&quot; but the result has to be filtered(distinct) because i have some duplicate rows and i only want to show ONE instance.<br />
<br />
regards
</div>


<div>
ok, then all you need to do is put the query inside parentheses and add .Distinct() &nbsp;and it will only return distinct rows
</div>


<div>
that is my query as shown in my previous post<br />
<br />
<br />
Dim searchTrigger As IEnumerable(Of DataRow) = From r As DataRow In Me._dtTrigger.AsEnumerable<wbr /> _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Where r.Field(Of String)(&quot;BCEID&quot;).ToUpper Like searchBuilder.ToString _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Select r _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Distinct<br />
<br />
and i also tried this : <br />
<br />
searchBuilder.Append(&quot;*&quot;).<wbr />Append(sea<wbr />rchPattern<wbr />).Append(&quot;<wbr />*&quot;)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim searchTrigger As IEnumerable(Of DataRow) = (From r As DataRow In Me._dtTrigger.AsEnumerable<wbr /> _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Where r.Field(Of String)(&quot;BCEID&quot;).ToUpper Like searchBuilder.ToString _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Select r).Distinct<br />
<br />
<br />
as you can see, i put a distinct at the end of query but the result isn't distincted... <br />
<br />
Regards
</div>


<div>
I understand that, but have you tried putting it inside parentheses then distincting it, or just using distinct on the next line. &nbsp;You are putting it at the end, but not actually calling distinct properly.<br />

<pre><code class="code-1 nolinks" id="code-122304"><span>Dim distinctQuery = searchTrigger.Distinct()</span>
</code></pre>
</div>


<div>
that is the same... <br />
<br />
i tried your solution to be sure... but didn't work.
</div>


<div>
<div class="content wysiwyg-content">
Hi experts<br />
<br />
i have this LINQ <br />
<br />
Dim searchTrigger As IEnumerable(Of DataRow) = From r As DataRow In Me._dtTrigger.AsEnumerable<wbr /> _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Where r.Field(Of String)(&quot;BCEID&quot;).ToUpper Like searchBuilder.ToString _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Select r _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Distinct<br />
<br />
<br />
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...<br />
<br />
can you help me to achieve this?<br />
<br />
Kind regards<br />

</div>
</div>


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 _
                                                               Distinct


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


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

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,