コード例 #1
0
        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);
                });
            }
        }