예제 #1
0
        public void InitControl(SqlConnectionStringBuilder conn, string schema)
        {
            groupBox1.Controls.Clear();

            TableBusiness tableBusiness = new TableBusiness();

            try
            {
                List <Table> lstTable = tableBusiness.ListTables(conn, schema);

                TreeView tree = new TreeView();
                tree.ImageList   = lstImage;
                tree.Name        = "tvTables";
                tree.CheckBoxes  = true;
                tree.AfterCheck += new TreeViewEventHandler(tree_AfterCheck);
                tree.Dock        = DockStyle.Fill;
                AdvancedTreeNode node;
                AdvancedTreeNode nodeSon;

                foreach (Table table in lstTable)
                {
                    node                    = new AdvancedTreeNode();
                    node.Checked            = true;
                    node.Text               = table.Name;
                    node.Value              = table;
                    node.SelectedImageIndex = (int)DBImage.TABLE;
                    node.ImageIndex         = (int)DBImage.TABLE;
                    tree.Nodes.Add(node);
                    foreach (Column column in table.Columns)
                    {
                        nodeSon                    = new AdvancedTreeNode();
                        nodeSon.Checked            = true;
                        nodeSon.Text               = column.Name + " (" + ListarAtributos(column) + ")";
                        nodeSon.Value              = column;
                        nodeSon.SelectedImageIndex = GetImageIndex(column);
                        nodeSon.ImageIndex         = GetImageIndex(column);
                        node.Nodes.Add(nodeSon);
                    }
                }

                groupBox1.Controls.Add(tree);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #2
0
        public TreeView InitTreeView(string seach)
        {
            TableBusiness tableBusiness = new TableBusiness();
            TreeView      tree          = new TreeView();

            tree.Name       = "tvTables";
            tree.CheckBoxes = true;
            try
            {
                AdvancedTreeNode node;
                AdvancedTreeNode nodeSon;
                List <Table>     lstTable = tableBusiness.ListTables(ConnBuilder, seach);
                foreach (Table table in lstTable)
                {
                    node                    = new AdvancedTreeNode();
                    node.Checked            = true;
                    node.Text               = table.Name;
                    node.Value              = table;
                    node.SelectedImageIndex = (int)DBImage.TABLE;
                    node.ImageIndex         = (int)DBImage.TABLE;
                    tree.Nodes.Add(node);
                    foreach (Column column in table.Columns)
                    {
                        nodeSon                    = new AdvancedTreeNode();
                        nodeSon.Checked            = true;
                        nodeSon.Text               = column.Name + " (" + ListarAtributos(column) + ")";
                        nodeSon.Value              = column;
                        nodeSon.SelectedImageIndex = GetImageIndex(column);
                        nodeSon.ImageIndex         = GetImageIndex(column);
                        node.Nodes.Add(nodeSon);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return(tree);
        }