Janus System

'can not modify the control at this time' when trying to edit a Janus Grid

Steve Gray — Sat, 21 Feb 2009 22:51:00 GMT

I am in Visual Studio 2005, using 3.0.0.94 of the Janus Grid. The project is a special 'dynamics GP' type of project. If I add a standard form to the project, the grid will allow me to edit it. If I add a special form type called 'DynamicsGPForm', I get 'Can not modify the control at this time' for any type of editing task. The properties window performs as expected, though.

I've tried file permissions, I have 'everyone' set to 'full control'

Support suggested upgrading to V3.5, that fixed it.

Code for a 'contains' filter on a Janus grid

Steve Gray — Fri, 13 Feb 2009 19:53:00 GMT

This piece of code will do a 'contains' filter on a Janus grid

    Private Sub txtFilter_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim txtSubdivisionName As GridEXColumn


        'Get a reference of the column to be compared
        txtSubdivisionName = GridEX1.RootTable.Columns("vchrSubdivisionName")


        Dim intOperator As Janus.Windows.GridEX.ConditionOperator = ConditionOperator.Contains


        'Create the condition
        Dim condition As New GridEXFilterCondition(txtSubdivisionName, intOperator, Me.txtFilter.Text)
        'Assign the condition to the table to filter the records
        GridEX1.RootTable.FilterCondition = condition
    End Sub

This code will allow multiple filter conditions

 Private Sub filter()
    Dim colBidderNo As GridEXColumn
    Dim colCompany1 As GridEXColumn
    Dim strBidderNo As String = Me.txtBidderNo.Text
    Dim strCompany1 As String = Me.txtCompany1.Text


    'Get a reference of the column to be compared
    colBidderNo = GridEX1.RootTable.Columns("bidderno")
    colCompany1 = GridEX1.RootTable.Columns("company1")



    'Create the condition
    Dim condition As New GridEXFilterCondition
    If strBidderNo > "" Then
        condition.AddCondition(New GridEXFilterCondition(colBidderNo, ConditionOperator.Contains, strBidderNo))
    End If


    If strCompany1 > "" Then
        condition.AddCondition(New GridEXFilterCondition(colCompany1, ConditionOperator.Contains, strCompany1))
    End If


    ''Assign the condition to the table to filter the records
    If condition.Conditions.Count > 0 Then
        GridEX1.RootTable.FilterCondition = condition
    End If
End Sub

How to cause a Janus multicolumn dropdown to automatically drop down on cell entry

Steve Gray — Fri, 13 Feb 2009 19:20:00 GMT

This piece of code will cause a Janus multicolumn dropdown to automatically drop down when you enter the cell

    Private Sub GridEX1_CurrentCellChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridEX1.CurrentCellChanged
        Me.GridEX1.CurrentCellDroppedDown = True
    End Sub