DataGridView Calculated Column update when move to new row C#

See more:

SQL-Server-2005

C#

SQL-Server

, +

Hi to All,

I am using Visual Studio 2010 with Sql server Express Edition 2005 as backend DB. I've a form with DataGridView with following columns:

OrderID ProductID UnitPrice Quantity Total

DataGridView is bind to Dataset Table, "Total" is a Calculated column which I've added using following code:

column = new DataColumn();
column.DataType = Type.GetType("System.Double");
column.ColumnName = "Total";
ds.Tables[0].Columns.Add(column);
ds.Tables[0].Columns["Total"].Expression = "UnitPrice * Quantity";

Code works fine, it calculate the Total by multiplying UnitPrice to Quantity. The problem is this calculation is made when I move to new row. What I need is to it calculate Total when there is any change in UnitPrice or Quantity.

Is it possible? Any ideas/suggestions will be highly appreciated.

Regards

Ahmed