Datagrid, calculating 2 columns and putting the result a 3rd column

Hello,

2005 VS WM 6.0

I have a datagrid with columns Quantity Price, and Total.

The validating event of the datagrid will fire when the a new quantity is entered into the quantity cell, then the calculation will happen in that event.

Is the validating event the best event to use when making a calculation like this?

The datagrid is bound to a typed dataset.

When doing the calculation is it best to get the current row and then calculate the 2 columns? Or is this better with using the Table.Compute method?

Many thanks for any code examples or advice,

Steve