I have a data grid view with QUANTITY, UNIT PRICE and VALUE columns. What I want to do is when changing the QUANTITY I need to change the VALUE .
VALUE = QUANTITY \* UNIT PRICE

I wrote code for gridview 'CellValueChanged' event. But then VALUE will change when leaving the cell only. I need to change VALUE when typing the QUANTITY.

My code like this.Any idea please. 

```
private void dgvSale_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
    if (dgvSale.Columns[e.ColumnIndex].Name == "Qty")
    {
       double qty = Convert.ToDouble(dgvSale["Qty", dgvSale.CurrentRow.Index].Value);
       double rate = Convert.ToDouble(dgvSale["Rate", dgvSale.CurrentRow.Index].Value);
       double totVal = qty * rate;
       dgvSale["Value", dgvSale.CurrentRow.Index].Value = totVal.ToString("#,###.00");
    }
 }

```