Click here to Skip to main content
15,890,579 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Trying to create a search query that will bring the results searched in access database. It is bringing up an error runtime error '3075' Pin
Dave Kreskowiak15-Dec-18 5:16
mveDave Kreskowiak15-Dec-18 5:16 
QuestionHow to assign enter key? Pin
Member 1408751912-Dec-18 20:07
Member 1408751912-Dec-18 20:07 
AnswerRe: How to assign enter key? Pin
Richard MacCutchan12-Dec-18 22:00
mveRichard MacCutchan12-Dec-18 22:00 
Questionthe fast ways to create a list Pin
desanti11-Dec-18 4:36
desanti11-Dec-18 4:36 
AnswerRe: the fast ways to create a list Pin
Richard Deeming11-Dec-18 5:30
mveRichard Deeming11-Dec-18 5:30 
GeneralRe: the fast ways to create a list Pin
desanti11-Dec-18 5:40
desanti11-Dec-18 5:40 
GeneralRe: the fast ways to create a list Pin
Eddy Vluggen11-Dec-18 6:39
professionalEddy Vluggen11-Dec-18 6:39 
QuestionFill Treeview using recursion Pin
sterenas7-Dec-18 10:15
sterenas7-Dec-18 10:15 
Hi,
Wonder if there's a better approach to fill a Treeview recursively. Following snippet fills the Treeview but if I need an extra level I'd have to create yet another Sub. There must be a way of doing it recursively? Also I'm not able to show CategoryName on every node (please see tree representations below):
IdCategory	CategoryName	ParentCategory
15		Uncategorized	0
50		Animals		0
51		Plants		0
52		Dogs		50
53		Small		52
54		Medium		52
55		Large		52
56		Trees		51
57		Flowers		51
58		White		55
59		Brown		55


I call FillRootLevel and get the following:
0
  Animals
  Plants
  Uncategorized
50
  Dogs
51
  Flowers
  Trees
52
  Large
  Medium
  Small
55
  Brown
  White


VB
Private Sub FillRootLevel()
   tvCategories.Nodes.Clear()
   dtCategories = obj.ListCategories().Tables("Data")
   For Each dr As DataRow In dtCategories.Rows
       Dim node As New TreeNode With {
           .Text = dr("IdCategory"),
           .Tag = dr("CategoryName")
       }
       tvCategories.Nodes.Add(node)
       FillParentCategories(node.Tag, node)
    Next
End Sub

Private Sub FillParentCategories(ByVal strNodeTag As String, ByVal parentnode As TreeNode)
   dtParentCategories = obj.ListParentCompanies().Tables("Data")
   For Each dr As DataRow In dtParentCategories.Rows
       Dim node As New TreeNode With {
           .Text = dr("ParentCategory"),
           .Tag = dr("ParentCategory")
       }
       parentnode.Nodes.Add(node)
       FillCategories(node.Tag, node)
    Next
End Sub

Private Sub FillCategories(ByVal strParentCategory As String, ByVal parentnode As TreeNode)
    dtCategories = obj.ListCategories(strParentCategory).Tables("Datos")
    For Each dr As DataRow In dtCategories.Rows
        Dim node As New TreeNode With {
            .Text = dr("CategoryName"),
            .Tag = dr("CategoryName")
        }
        parentnode.Nodes.Add(node)
    Next
End Sub


I'd need:
Uncategorized
Animals
  Dogs
    Large
      Brown
      White
    Medium
    Small
Plants
   Flowers
   Trees

Searched quite a bit for a solution but couldn't find a VB.NET / C# acceptable one.
Thanks for any help you may provide!
Sergio

modified 7-Dec-18 18:33pm.

AnswerRe: Fill Treeview using recursion Pin
Eddy Vluggen8-Dec-18 0:12
professionalEddy Vluggen8-Dec-18 0:12 
AnswerRe: Fill Treeview using recursion Pin
Eddy Vluggen8-Dec-18 1:46
professionalEddy Vluggen8-Dec-18 1:46 
GeneralRe: Fill Treeview using recursion Pin
sterenas8-Dec-18 4:26
sterenas8-Dec-18 4:26 
GeneralRe: Fill Treeview using recursion Pin
Eddy Vluggen8-Dec-18 4:37
professionalEddy Vluggen8-Dec-18 4:37 
GeneralRe: Fill Treeview using recursion Pin
sterenas10-Dec-18 3:52
sterenas10-Dec-18 3:52 
GeneralRe: Fill Treeview using recursion Pin
Eddy Vluggen11-Dec-18 2:08
professionalEddy Vluggen11-Dec-18 2:08 
GeneralRe: Fill Treeview using recursion Pin
sterenas11-Dec-18 5:34
sterenas11-Dec-18 5:34 
GeneralRe: Fill Treeview using recursion Pin
Eddy Vluggen11-Dec-18 6:16
professionalEddy Vluggen11-Dec-18 6:16 
GeneralRe: Fill Treeview using recursion Pin
sterenas11-Dec-18 7:51
sterenas11-Dec-18 7:51 
GeneralRe: Fill Treeview using recursion Pin
Eddy Vluggen11-Dec-18 23:10
professionalEddy Vluggen11-Dec-18 23:10 
Questionentity framework Group by multiple columns and count the number of groups with more than 1 item Pin
desanti6-Dec-18 11:24
desanti6-Dec-18 11:24 
AnswerRe: entity framework Group by multiple columns and count the number of groups with more than 1 item Pin
Richard Deeming7-Dec-18 7:46
mveRichard Deeming7-Dec-18 7:46 
QuestionProblems with Entity Famework and bindingsources Pin
desanti6-Dec-18 0:13
desanti6-Dec-18 0:13 
QuestionDrawlines is correct or not ? Pin
Coffee_Break5-Dec-18 1:27
Coffee_Break5-Dec-18 1:27 
AnswerRe: Drawlines is correct or not ? Pin
Eddy Vluggen5-Dec-18 2:05
professionalEddy Vluggen5-Dec-18 2:05 
Questionsave my excel invoice in excel sheet Pin
kami1244-Dec-18 8:04
kami1244-Dec-18 8:04 
QuestionRe: save my excel invoice in excel sheet Pin
Richard MacCutchan4-Dec-18 8:58
mveRichard MacCutchan4-Dec-18 8:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.