How to get a column of data from ADO.NET Datatable USING GROUP BY a column?
<p>I have a Datatable as Following</p>

<pre><code>ID  ITEM_Code  
1   1001  
2   1002  
3   1003  
4   1002  
5   1003  
6   1004  
7   1005  
8   1006  
9   1007  
10  1006
</code></pre>

<p>Now I want to get <code>ITEM_CODE</code> which exists only once. From the database I can get data by using group by shown below</p>

<pre><code>SELECT ITEM_Code 
FROM ITEM_TABLE 
GROUP BY ITEM_Code  
HAVING COUNT(ITEM_Code) = 1
</code></pre>

<p>Result: </p>

<pre><code>ITEM_CODE  
1001  
1004  
1005  
1007
</code></pre>

<p>I have <code>ITEM_TABLE</code> data in ADO.NET datatable</p>

<p>I want to get <code>ITEM_CODE</code> which exists only once from the ADO.NET <code>Datatable</code> into any variable.</p>

<p>How can I do this in an optimum way?</p>
