<div>
is that what you are looking for?<br />
<br />

<pre><code id="code-20-36943867-1">var query = (from x in datatable
                    select new(col1 = x.col1, col2 = x.col2)).distinct()</code></pre>
</div>


is that what you are looking for?



var query = (from x in datatable
                    select new(col1 = x.col1, col2 = x.col2)).distinct()

<div>
I get cannot convert lamba to delegate type
</div>


I get cannot convert lamba to delegate type

<div>
<a href="http://msdn.microsoft.com/en-us/vcsharp/aa336761.aspx#distinct1" rel="ugc nofollow">http://msdn.microsoft.com/en-us/vcsharp/aa336761.aspx#distinct1</a>
</div>


http://msdn.microsoft.com/en-us/vcsharp/aa336761.aspx#distinct1 [http://msdn.microsoft.com/en-us/vcsharp/aa336761.aspx#distinct1]

<div>
<div class="content wysiwyg-content">
Hi.. <br />
I have a data taAble with 10 columns... I need to return a data table with the unique values based on COL 1 and COL2 . &nbsp; Any ideas ? &nbsp;Maybe Linq? &nbsp; Need some code examples please.
</div>
</div>


Hi.. 
I have a data taAble with 10 columns... I need to return a data table with the unique values based on COL 1 and COL2 .   Any ideas ?  Maybe Linq?   Need some code examples please.

C#  Get Unique DataRows based on 2 columns

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).