protected void TreeView1_TreeNodeExpanded(object sender, TreeNodeEventArgs e) { if (e.Node.Depth == 1) { List <string> tables = getInfos.getTables(e.Node.Text); tables.ForEach(t => { TreeNode tb = new TreeNode(t); e.Node.ChildNodes[0].ChildNodes.Add(tb); }); List <string> views = getInfos.getViews(e.Node.Text); views.ForEach(v => { TreeNode view = new TreeNode(v); e.Node.ChildNodes[1].ChildNodes.Add(view); }); List <string> procedures = getInfos.getProcedures(e.Node.Text); procedures.ForEach(p => { TreeNode procedure = new TreeNode(p); e.Node.ChildNodes[2].ChildNodes.Add(procedure); }); List <string> functions = getInfos.getFunctions(e.Node.Text); functions.ForEach(f => { TreeNode function = new TreeNode(f); e.Node.ChildNodes[3].ChildNodes.Add(function); }); } }