Link to home
Start Free TrialLog in
Avatar of printmedia
printmedia

asked on

Cannot open same form multiple times on treeview control unless I click another node and come back vb.net

Hi all.

I have a treeview control (vb.net in Visual Studio) with multiple nodes, when the end user clicks on a node it opens a specific form. This is working fine, but I notice something peculiar:

When I click nodeA, it opens formA. I then decide to click on nodeB, and it opens formB as it should.

Now, let's say I click nodeA, it opens formA. Now I want to open another instance of formA so I click nodeA again but nothing happens, it doesn't open formA again. The only way to get formA to open again is to click on nodeB or another treeview level (parent node etc.) and then go back to nodeA and click it and then it'll open another instance of formA.

Any idea how I can open the same form multiple times by clicking the node multiple times without having to click some different node and then coming back to the original node to open the form multiple times?

Thank you in advance.

Private Sub TreeView1_AfterSelect(sender As Object, e As TreeViewEventArgs) Handles TreeView1.AfterSelect

        Dim con As New SqlConnection
        Dim cmd As New SqlCommand
        Dim frm As String

        con.ConnectionString = "Data Source=myServer;Initial Catalog=myDB;Integrated Security=True"

        con.Open()

        cmd.Connection = con

        If e.Node.Text = "MyApp" Then
            Exit Sub

        Else
            cmd.CommandText = "SELECT FormName FROM Menu WHERE Application = @Form"
            cmd.Parameters.AddWithValue("@Form", TreeView1.SelectedNode.Text)

            frm = cmd.ExecuteScalar()
            con.Close()

            If frm Is Nothing Then  'The selected node does not have a form
                Exit Sub
            Else

                Dim f As Form = GetFormByName(frm)

                f.Show()    'Open the form selected in the TreeView control

                Me.BringToFront()   'Bring the MyAppMenu form to the front to be able to have it appear behind the other forms in the next line
                Me.SendToBack()     'Send the MyAppMenu form behind the form just opened in the f.show() line
            End If
        End If

    End Sub

Private Function GetFormByName(ByVal pFormName As String) As Form
        'Try to create a type form using the name specific in pFormName. The False is to prevent an exception because in the If statement we are checking if the Type is null (meaning nothing found)
        Dim T As Type = Type.GetType(pFormName, False)

        If T Is Nothing Then    'If nothing is found then add the current namespace (ie. MyApp.Prospects)

            Dim strFullname As String = Application.ProductName & "." & pFormName
            T = Type.GetType(strFullname, True, True)   'The second True is to do a case-insensitive search for strFullname

        End If

        Return CType(Activator.CreateInstance(T), Form)

    End Function

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of printmedia
printmedia

ASKER

Thanks again Eric. That was it. I changed my parameter code to be e.Node.Text instead of TreeView1.SelectedNode.Text. And it works like a charm now.

cmd.Parameters.AddWithValue("@Form", e.Node.Text)

Open in new window