treeview dynamically populated
- by Laziale
Hello everyone -
I have this treeview control where I want to put uploaded files on the server.
I want to be able to create the nodes and the child nodes dynamically from the database.
I am using this query for getting the data from DB:
SELECT c.Category, d.DocumentName FROM Categories c
INNER JOIN DocumentUserFile d
ON c.ID = d.CategoryId
WHERE d.UserId = '9rge333a-91b5-4521-b3e6-dfb49b45237c'
The result from that query is this one:
Agendas
transactions.pdf
Minutes
accounts.pdf
I want to have the treeview sorted that way too.
I am trying with this piece of code:
TreeNode tn = new TreeNode();
TreeNode tnSub = new TreeNode();
foreach (DataRow dt in tblTreeView.Rows)
{
tn.Text = dt[0].ToString();
tn.Value = dt[0].ToString();
tnSub.Text = dt[1].ToString();
tnSub.NavigateUrl = "../downloading.aspx?file=" + dt[1].ToString() +"&user=" + userID;
tn.ChildNodes.Add(tnSub);
tvDocuments.Nodes.Add(tn);
}
I am getting the treeview populated nicely for the 1st category and the document under that category, but I can't get it to work when I want to show more documents under that category, or even more complicate to show new category beneath the 1st one with documents from that category.
How can I solve this?
I appreciate the answers a lot.
Thanks, Laziale