Distinct rows from Datatable on basis of value of one column... rather than all column
<p>I have a datatable, i want to get distinct rows on the basis of value of one column instead of getting distinct rows on basis of all column in row of datatable. since we can get distinct rows as follows</p>

<pre><code>datatableName.DefaultView.ToTable("true","ColName");
</code></pre>

<p>since in ToTable() we have to specify all column to be displayed. Please help me so that i can be able to get distinct rows having all column displyed and only one column is used to get distinct rows.</p>

<p>Example sample rows, which i have are as follows</p>

<pre><code>ID Application English Spanish German
1  sam         thnks   thnkd   thkng
2  smp         thnks   thnke   thnkp
3  anp         same    same    same
</code></pre>

<p>i want to get all those rows wwhich have different spanish/German Cloumn Value against English Column Value.....</p>

<p>Help in this regard will be much appreciated...</p>

<p>Thanks in advance</p>
