How to load TreeNavigator from DB

[Martin]

I am trying to load the TreeNavigator from a database based on user permissions. The list could be 3-4 child deep with some not having any children. I am trying to achieve this is VB.net.

Thanks, Martin

[Sabaridass Ramamoorthy]

Hi Martin, 

 

Thanks for contacting Syncfusion Support. 

 

We have prepared a simple sample to achieve your requirement and it can be downloaded from below location. 

http://www.syncfusion.com/downloads/support/forum/144296/ze/WF_TreeNavigatorDirectory2112430474  

 

Kindly refer to the below code example which helps you to add child nodes based on your needs. 

#Form1.cs 

 

private void TreeNavigator1_SelectionChanged(TreeNavigator sender, SelectionStateChangedEventArgs e) 

        { 

            TreenavigatorItemsUpdate(treeNavigator1, e); 

        } 

        private void TreenavigatorItemsUpdate(TreeNavigator sender, SelectionStateChangedEventArgs e) 

        { 

            TreeNavigator tree = sender as TreeNavigator; 

            dataBaseView.Table.Rows.Cast<DataRow>().ToList().ForEach(x => 

               { 

                   if (dataBaseView.Table.Columns.Contains(e.SelectedItem.Text)) 

                       e.SelectedItem.Items.Add(new TreeMenuItem() { Text = x[dataBaseView.Table.Columns[e.SelectedItem.Text]].ToString() }); 

               }); 

            

        } 

 

If the above solution doesn’t meet your actual requirement, you can share some more detailed information about your requirement. So that we could provide the solution at the earliest. 

 

Regards, 

Sabaridass R 

 

[Martin]

Hi, Thanks for the example. Am i right in thinking that you only add the child items upon each click of the parent and not load them at the start? Also i am having an issue converting to VB, do you have any samples in VB?

Thanks, Martin

[Sabaridass Ramamoorthy]

Hi Martin, 

 

You can also add child nodes at the beginning while adding parent nodes. Kindly refer to the below code example. 

Private Sub FillItems(ByVal tree As TreeNavigator) 

                For Each col As DataColumn In dataBaseView.Table.Columns 

                           Me.treeNavigator1.Items.Add(New TreeMenuItem() With {.Text = col.ColumnName}) 

                Next col 

                     For Each x As DataRow In dataBaseView.Table.Rows 

                           For Each y As TreeMenuItem In Me.treeNavigator1.Items 

                                  If dataBaseView.Table.Columns.Contains(y.Text) Then 

                                         y.Items.Add(New TreeMenuItem() With {.Text = x(dataBaseView.Table.Columns(y.Text)).ToString()}) 

                                  End If 

 

                           Next y 

                     Next x 

              End Sub 

 

We have prepared a sample in VB with modified code changes and it can be downloaded from below location. 

http://www.syncfusion.com/downloads/support/forum/144296/ze/WF_TreeNavigatorDirectory(1)1297484644  

 

Regards, 

Sabaridass R 

[Martin]

Thank you, i have successfully got the parent and child node working. But how would i go about adding a child to a child? I need to be able to go 5 childs deep.

Thanks, Martin

[Jagadeesan Pichaimuthu]

  

Hi Martin,

Thanks for the update.

In TreeNavigator there is no default support to bind items through Database and it can be achieved by loading TreeMenuItem in iteration process from DataTable. We have modified the sample as per your requirement and it can be downloaded from below location.

Sample: TreeNavigator_DataBinding 

In this sample we have initialized the DataTable with required data, integrated the DataTable in DataSet and created and loaded TreeMenuItem in TreeNavigator. 

Please check the above sample and let us know if you require further assistance on this.

Regards, 

Jagadeesan