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
37 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

19 Experts available now in Live!

Get 1:1 Help Now