Hi,
I am trying to load my items from Database to a Treeview but i have faild
My table contains id, parentId, nodeName like following:
(1 , 1 RootNode)
(2 , 2 , ParentNode)
(3, 2 , Child_for_2)
(4, 4 , AnotherParent)
(5 , 2 , anotherChild_for_2)
(6 , 4 , Child_for_4)
My problem is ,how i can create a treeview from this rows ( need some code).
here is a bit of my code what i have been trying for 6 hours.
try
{
treeView.BeginUpdate();
DataSet DS = new DataSet();
DS = MyWebService.LoadTreeViewFromDB();
if (DS != null)
{
TreeNode Root = new TreeNode("Taxonomy");
Root.Tag = 1;
treeView.Nodes.Add(Root);
TreeNode ParentNode = null;
foreach (DataRow DR in DS.Tables["folksonomy"].Rows)
{
TreeNode NewNode = new TreeNode();
if (DR["id"].ToString() == DR["parentid"].ToString())
{
NewNode.Text = DR["nodename"].ToString();
NewNode.Tag = DR["id"].ToString();
Root.Nodes.Add(NewNode);
}
else
{
foreach (DataRow ChildDataRow in DS.Tables["folksonomy"].Rows)
{
if (ChildDataRow["id"].ToString() == DR["parentid"].ToString())
{
I dont know what i should write here
}
}
}
}
}