做了一个类似简单的利润计算
Dim ddbh As String = e.DataRow("订单编号")
Select Case e.DataCol.Name
Case "收入","支出"
Dim sr As Double
Dim zc As Double
Dim ye As Double
sr = e.DataTable.Compute("sum(收入)","[订单编号] = '" & ddbh & "'")
zc = e.DataTable.Compute("sum(支出)","[订单编号] = '" & ddbh & "'")
ye = sr - zc
MessageBox.Show(ddbh)
MessageBox.Show(sr)
MessageBox.Show(zc)
MessageBox.Show(ye)
Dim ddlr As DataRow = DataTables("订单").Find("[订单编号] = '" & ddbh & "'")
ddlr("利润") = ye
End Select
代码应该没什么问题,直接在表中修改收入和支出,运算没有问题,但是做了个窗口,控件TextBox绑定到收入或者支出列,在TextBox控件中写数值,代码执行计算有问题,好像是当前的值不参与计算,只是计算保存之前的数值,怎么解决?为什么会这个样子?