TB.TreeGrid

TreeGrid tg = new TreeGrid();

DataTable ItemTable = new DataTable("MyTable");
ItemTable.Columns.Add("FunctionID", typeof(int));
ItemTable.Columns.Add("ParentID", typeof(int));
ItemTable.Columns.Add("FunctionName", typeof(String)); // add some test data

ItemTable.Rows.Add(new object[] { 0,-1, "Bill Gates"    });
ItemTable.Rows.Add(new object[] { 1, 0, "Steve Ballmer" });
ItemTable.Rows.Add(new object[] { 3, 1, "Mary Smith"    });
ItemTable.Rows.Add(new object[] { 2, 0, "Paul Allen"    });
ItemTable.Rows.Add(new object[] { 4, 2, "Ahmed Jones"   });
ItemTable.Rows.Add(new object[] { 5, 2, "Wing Lee"      });

DataRow[] SortedRows;
SortedRows = ItemTable.Select("", "ParentID");

XmlDocument XDoc = new XmlDocument();
XmlDeclaration XDec = XDoc.CreateXmlDeclaration("1.0", null, null);
XDoc.AppendChild(XDec);
foreach (DataRow Row in SortedRows)
{

    XmlElement NewNode = XDoc.CreateElement("_" + Row["FunctionID"].ToString());
    NewNode.SetAttribute("FunctionID", Row["FunctionID"].ToString());
    NewNode.SetAttribute("ParentID", Row["ParentID"].ToString());
    NewNode.SetAttribute("FunctionName", Row["FunctionName"].ToString());

    if ((int)Row["ParentID"] == -1)
    {
           XDoc.AppendChild(NewNode);  // root node

          
     }
     else
     {
            String SearchString;
            SearchString = String.Format("//*[@FunctionID=\"{0}\"] ", Row["ParentID"].ToString());
            XmlNode Parent = XDoc.SelectSingleNode(SearchString);
            if (Parent != null)
                Parent.AppendChild(NewNode);
      }
     }

XmlDataSource XDdataSource = new XmlDataSource();
XDdataSource.ID = DateTime.Now.Ticks.ToString();  // unique ID is required
XDdataSource.Data = XDoc.OuterXml;


tg.DataSource = XDdataSource;
tg.DataBind();