Janus GridEX: Update the totals row in a Janus GridEX and then use the updated value in a control

Platform:Janus GridEX
Task:Update the totals row in a Janus GridEX and then use the updated value in a control
Discussion:
Update the totals row in a Janus GridEX and then use the updated value in a control
Example:
    Private Sub Tbl_SurveySearchWindowsGridEX_SelectionChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Tbl_SurveySearchWindowsGridEX.SelectionChanged
        UpdateElapsedTime()
    End Sub

    Private Sub UpdateElapsedTime()
        'Show total row
        Tbl_SurveySearchWindowsGridEX.TotalRow = Janus.Data.InheritableBoolean.True
        'Showing Sum in Amount column
        Tbl_SurveySearchWindowsGridEX.RootTable.Columns("ElapsedTime").AggregateFunction = Janus.Data.AggregateFunction.Sum
        Me.ElapsedTimeTextBox.Text = Tbl_SurveySearchWindowsGridEX.GetTotal(Tbl_SurveySearchWindowsGridEX.RootTable.Columns("ElapsedTime"), Janus.Windows.GridEX.AggregateFunction.Sum)
    End Sub
Back to Index