Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0treeviewtreeview
Previous
 
Next
New Post
7/14/2009 10:26 AM
 

After some works I finnaly do what I need with this code:

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

void fill_tree()
        {
            DataSet ds = data_set("SELECT * FROM Information_Schema.tables ORDER BY table_name");

            TreeView1.Nodes.Clear();

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

                parent.Text = dr["TABLE_NAME"].ToString();
                parent.PopulateOnDemand = true;
                parent.ToolTip = "Click para obter as colunas";
                parent.SelectAction = TreeNodeSelectAction.SelectExpand;
                parent.Expand();
                parent.Collapse();
                TreeView1.Nodes.Add(parent);

                DataSet dstwo = data_set("SELECT * FROM information_schema.columns WHERE table_name LIKE '" + dr["TABLE_NAME"].ToString() + "' ORDER BY column_name");

                foreach (DataRow drtwo in dstwo.Tables[0].Rows)
                {

                    TreeNode child = new TreeNode();

                    child.Text = drtwo["column_name"].ToString();
                    child.PopulateOnDemand = true;
                    parent.ChildNodes.Add(child);
                }

            }
        }

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

 

But not I had another question, I want to click on one parent node and show the rows of that table in a grid view.

My problem is how to make the node clickable to call a function or something like that.

 
New Post
7/16/2009 5:12 AM
 

Once again I had solve all that, it's all working, but now I really have something that i don't know how to make.

I have populate the gridview with a gr.datasourse and gv.databiding();

Now I click on a tree node(that is a table name) and it show all the rows in a gridview.
Now what i want to do is to select a row, the function is already created, and show the row info in a label, like this.

column1: info1
column2: info2
...

 

but only for that selected row.
I already try it, but it said me that I need to give the gridview the datanamekeys, but because the gridview is populated with code i don't know how can do it, because the datanamekeys will be allways changing acording to my selection table on treeview.


 

 
New Post
8/6/2009 11:18 AM
 

About his, I have now two modules, one with a form to create new nodes, and other only with the treeview.
My question is, can I refresh the treeview by click on the button from the form?

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0treeviewtreeview


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out