title: In SQL, how to multiply data of two columns for third column
body: <p>I want to multiply the data of two columns and show it in the third column.</p>
  
  <p>For example:</p>
  
  <pre>
  1st Column: Quantity
  2nd Column: Rate
  3rd Column: Price
  </pre>
  
  <p>I want to multiply as user enters the data for quantity and rate like <code>Quantity=2</code>, <code>rate=50</code> automatically in price column I want 100 to be mentioned.</p>
  
  <p>Using C#, VS2010, SQL 2008</p>
  
  <p><strong>Edit:</strong> I want to show the data at the <code>DataGridView</code> what are the possible solutions, I used <code>DataAdapter</code> and <code>DataSet</code> to update the database:</p>
  
  <pre><code>this.table2TableAdapter.Update(testingDataSet);
  </code></pre>