0

Hello all, i have a problem and im in need of your help... I have a treeview with 2 parent Nodes and in the parent nodes there are some node:

Members
     New
     Search
Administration
    Groups
    Photo Location

In all nodes there is a checkbox for a spesific reason, like this:

(checkbox) Members
(checkbox)     New
(checkbox)     Search
(checkbox) Administration
(checkbox)    Groups
(checkbox)    Photo Location

What i want to do is to insert all the info that the treeview has into a Access Database. I can insert all the child nodes of the treeview into the db but i cant insert the Parent Nodes

Here are the funtions that i use to add the child nodes:

1.

Private Sub SaveTree(ByRef Treeview As Telerik.WinControls.UI.RadTreeView)

        For Each Node As Telerik.WinControls.UI.RadTreeNode In Treeview.Nodes
            SaveNode(Node)
        Next

    End Sub

2.
Red = Function that is not included.

Private Sub SaveNode(ByRef TreeNode As Telerik.WinControls.UI.RadTreeNode)
        Dim con As New OleDbConnection
        Dim command As New OleDbCommand
        Dim trans As OleDbTransaction = Nothing
        Dim RightID As Integer
        Dim GroupID As Integer
        Dim InsertString As String

        GroupID = functions.GetInfo(connstring, "SELECT ID FROM Groups WHERE GroupName = '" & cmbProperty.Text & "'", "Group", "ID")

        RightID = functions.GetNextVal(connstring, "Right")
        functions.InsertWithoutMessage(con, connstring, trans, command, "INSERT INTO Rights(ID,RightName) VALUES(" & RightID & ",'" & txtRightName.Text & "')")

        For Each Node As Telerik.WinControls.UI.RadTreeNode In trvForms.Nodes 'TreeNode.Nodes
            InsertString = "INSERT INTO Group_Right_Forms(Group_ID,Right_ID,Form_ID,ShowRight,InsertRight,UpdateRight,DeleteRight) VALUES(" & GroupID & "," & RightID & "," & Node.Tag & "," & Node.Checked.ToString() & "," & GetPanel(Node.Tag).InsertCheck.Checked.ToString() & "," & GetPanel(Node.Tag).UpdateCheck.Checked.ToString() & "," & GetPanel(Node.Tag).DeleteCheck.Checked.ToString() & ")"
            functions.InsertWithoutMessage(con, connstring, trans, command, InsertString)
            For Each Child As Telerik.WinControls.UI.RadTreeNode In Node.Nodes
                SaveNode(Child)
            Next
        Next

    End Sub

WHAT I WANT TO DO IS TO CHANGE SOMETHING SO AS TO INSERT INTO THE DATABASE ALL THE TREE(PARENT AND CHILD).... PLZ ANY CHANGES MADE PLZ MARK THEM WITH RED COLOR SO I CAN UNDERSTAND WHAT HAVE I DONE WRONG... :)


PS: Answer as soon as possible, as the title says "It is Urgent!!!"

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Ezzaral
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.