title: Grouping rows in a DataTable by column, then summing the contents of other columns in that group
body: <p>I have a DataTable in C# that looks something like this:</p>
  
  <pre><code>name | amount | other columns...
  --------------------------------
    x  |   10   |
    x  |   20   |
    y  |   42   |
    y  |    1   |
    y  |   23   |
  </code></pre>
  
  <p>And I'd like to write a method that returns something like this:</p>
  
  <pre><code>name | total
  -------------
    x  |  30
    y  |  66
  </code></pre>
  
  <p>More details on request:</p>
  
  <p>I'm getting the DataTable from the GetData query in the table below in a DataSet, what I need is the rows grouped by product(string) and the sum of productAmount(int).
  <img src="https://image.prntscr.com/image/2NQ3KaR8RI6tWOsVFoPYLA.png" alt=""></p>
  
  <p>Efficiency isn't really a concern, could anyone help?</p>
  
  <p>Further edit: In case it's relevant, I'm changing the DataTable to a DataView then applying a RowFilter based on the datePlaced column and then doing DataView.toTable() to get it back again before I want this query to run.</p>