Solved

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

Posted on 2016-07-28
2
29 Views
Last Modified: 2016-07-28
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

0
Comment
Question by:printmedia
2 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 41733121
because the AfterSelect event only occurs when a new node is clicked. Try the NodeMouseClick event instead: https://msdn.microsoft.com/en-us/library/system.windows.forms.treeview.nodemouseclick(v=vs.110).aspx
0
 

Author Comment

by:printmedia
ID: 41733149
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

0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now