DataTable.Select() Distinct then add values
<p>I just need to SELECT Distinct values from columnA then ADD the values that has joined to columnB</p>

<p>Sample:</p>

<pre><code>columnA    |    columnB
A                3
B                4
A                3
A                2 
B                1
C                3
</code></pre>

<p>Result:</p>

<pre><code>columnA        |    columnB
A                    8
B                    5
C                    3
</code></pre>

<p>i found <a href="http://stackoverflow.com/questions/1199176/how-to-select-distinct-values-from-datatable">this</a> but it just have the array of column names as parameter.</p>

<p>is there any other way or a sample using DataTable.Select()</p>

<p>Thanks in advance</p>
