hello again,

I need to make a treeview module. I already look to somehelp over the web about how to make a treeview with csharp.

But my problem is that I need to make a dynamic treeview with db acess, for any db.

Most of the hepl that I saw use nodes name write in code, not loading it from a db.

The output that I want to make for now is something like this:

treeview

table1

   ->row1

   ->row2

table2

    ->row1

.....

But something in csharp? =(

For now I have this code that show me in a treeview the tables as mother nodes, but now I want to show on the child nodes the columns from each table, using that second dataset sql.

How can I make it?

/***************/

protected void Page_Load(System.Object sender, System.EventArgs e)
        {
            try
            {
                fill_tree();
            }
            catch (Exception exc) //Module failed to load
            {
                Exceptions.ProcessModuleLoadException(this, exc);
            }

        }

        void fill_tree()
        {
            DataSet ds = data_set("select * from Information_Schema.tables");

            TreeView1.Nodes.Clear();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                TreeNode tn_parent = new TreeNode();

                tn_parent.Text = dr["TABLE_NAME"].ToString();
                tn_parent.PopulateOnDemand = true;
                tn_parent.ToolTip = "click to get child";
                tn_parent.SelectAction = TreeNodeSelectAction.SelectExpand;
                tn_parent.Expand();
                tn_parent.Selected = true;
                TreeView1.Nodes.Add(tn_parent);
                fill_child(tn_parent);
            }
        }

        public void fill_child(TreeNode parent)
        {
            DataSet dstwo = data_set(" /*** sql missing to show the columns for each table ***/ ");

            parent.ChildNodes.Clear();

            foreach (DataRow dr in dstwo.Tables[0].Rows)
            {
                TreeNode child = new TreeNode();
                child.Text = dr[" /*** columns numbers or something like that =S ***/ "].ToString();

                if (child.ChildNodes.Count == 0)
                {
                    child.PopulateOnDemand = true;
                }

                child.ToolTip = "click to get child";
                child.SelectAction = TreeNodeSelectAction.SelectExpand;
                child.CollapseAll();
                parent.ChildNodes.Add(child);
            }
        }

/***************/