Master-Detail Datagrid sum up problem

[Agnes]

I got master-detail datagrid
in my datagrid (invoicedetail) , aim(as the user type the unit price or no
of unit), the amount will be calculated and the TOTAL amount can be showed
in the form at once.

In my columnchanged event
e.Row("invamt") = e.Row("unitprice") * e.Row("noofunit") *
e.Row("exrate")
drInvInfo =
Me.dsSeaInvInfo.Tables("invoiceHeader").Rows(bmSeaInvInfo.Position)
For Each drInvCharges In drInvInfo.GetChildRows("fk_invno")
decTtlAmt = decTtlAmt + drInvCharges("invamt") <--- it
seems fail
Next
Me.txtTotalAmt.Text = decTtlAmt
How can I sum up the detail tables before I update the tables ??
Thanks

 

[Ken Tucker [MVP]]

Hi,

Try this.

decTtlAmt = decTtlAmt + Cdec(drInvCharges("invamt"))

Ken
---------------

I got master-detail datagrid
in my datagrid (invoicedetail) , aim(as the user type the unit price or no
of unit), the amount will be calculated and the TOTAL amount can be showed
in the form at once.

In my columnchanged event
e.Row("invamt") = e.Row("unitprice") * e.Row("noofunit") *
e.Row("exrate")
drInvInfo =
Me.dsSeaInvInfo.Tables("invoiceHeader").Rows(bmSeaInvInfo.Position)
For Each drInvCharges In drInvInfo.GetChildRows("fk_invno")
decTtlAmt = decTtlAmt + drInvCharges("invamt") <--- it
seems fail
Next
Me.txtTotalAmt.Text = decTtlAmt
How can I sum up the detail tables before I update the tables ??
Thanks