How to remove the duplicate rows by summing up the required columns in a datatable
<p>Hi all I am having my data table which is from my database is as follows</p>

<pre><code>Name       Total
XYZ         20
XYZ         20
ABC         20
</code></pre>

<p>Now I would like to have my data table as follows</p>

<pre><code>Name       Total
XYZ         40
ABC         20
</code></pre>

<p>I tried this <code>linq</code> from here <a href="http://stackoverflow.com/questions/13062875/find-duplicate-and-merge-record-into-single-datatable-c-sharp">Find duplicate and merge record into single datatable c#</a> which works fine but as I am having my values from database I don't know the type of the variable so can some one help me and give me the solution in non-linq way</p>
