title: LINQ DataTable Select Distinct Rows
body: <p>I am trying to get the distinct row with sum of each duplicate rows</p>
  
  <pre><code>DataTable newItems = new DataTable();
  
  newItems.Columns.Add("Qty");
  newItems.Columns.Add("BarcodeNumber");
  newItems.Columns.Add("DisplayName");
  newItems.Columns.Add("UnitPrice");
  newItems.Columns.Add("TotalPrice");
  
  newItems.Rows.Add(1, "URT29384", "Wallet", 88.8, 88.8);
  newItems.Rows.Add(1, "URT29233", "Mouse", 4.44, 4.44);
  newItems.Rows.Add(1, "URT29756", "Flash Drive", 1.47, 1.47);
  newItems.Rows.Add(1, "URT29323", "Spoon", 99.95, 99.95);
  newItems.Rows.Add(1, "URT29384", "Wallet", 88.8, 88.8);
  newItems.Rows.Add(1, "URT29384", "Wallet", 88.8, 88.8);
  </code></pre>
  
  <p>i want the result to be </p>
  
  <pre><code> 3 URT29384  Wallet       266.4     266.4
   1 URT29233  Mouse          4.44      4.44
   1 URT29756  Flash Drive    1.47      1.47
   1 URT29323  Spoon         99.95     99.95
  </code></pre>
  
  <p>is this possible using LINQ? a little help here.. TYIA</p>