I'm building an app in C# in the Visual Studio 2008 Express Edition that uses two datagridview controls in a master / detail relationship.
On the master datagridview I want to reflect a summary column from the details records for each master record. In particular, the master datagridview shows bills outstanding, and the details datagridview shows payments towards each of those bills.
So, for each row in the master datagridview I want to have an unbound column that displays the total amount paid to each of the bills. I'm very comfortable with the SQL side of this task, but I'm trying to pin down how (and when, in the lifecycle of the master datagridview control) I go about updating the column in each row to show the summed payment amounts.
Both datagridview controls on the form are based on TableAdapter / BindingSource controls.