title: C# SQL SUM value to a label
body: <p>I currently have a DataGridView which displays all the item. I would like to sum all the prices in the price column and then reflect the total in a label, 'TotalValueLabel'. What's wrong with my statement?</p>
  
  <pre><code>        string query = "SELECT SUM (Price) FROM Bill";
          OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, DBconn);
          DataTable source = new DataTable();
          dAdapter.Fill(source);
          TotalValueLabel.Text = source.ToString();
  </code></pre>