Treeviw 根据数据库自动生成

public TreeNode addSubNode(TreeNode parenttree, DataTable dt)
{
TreeNode TreeNodes = new TreeNode();
TreeNodes = parenttree;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable mydt = new DataTable();
SQLSERVERHelper sqldb = new SQLSERVERHelper();

mydt = sqldb.Get_DataTable("exec Greef_menu_tree_Index '" + dt.Rows[i]["menu_index"].ToString() + "'");
if (mydt == null)
{

TreeNode SubTreeNodes = new TreeNode();
SubTreeNodes.Text = dt.Rows[i]["menu_name"].ToString();
SubTreeNodes.NavigateUrl = dt.Rows[i]["menu_linkurl"].ToString();
TreeNodes.ChildNodes.Add(SubTreeNodes);

}
else
{
TreeNode SubTreeNodes = new TreeNode();
SubTreeNodes.Text = dt.Rows[i]["menu_name"].ToString();
SubTreeNodes.NavigateUrl = dt.Rows[i]["menu_index"].ToString();
TreeNodes.ChildNodes.Add(addSubNode(SubTreeNodes, mydt));

}

}
}
// parenttree.ChildNodes.Add(TreeNodes);

return TreeNodes;

}

 

 

DataTable mysdt = new DataTable();
SQLSERVERHelper sqldb = new SQLSERVERHelper();
mysdt = sqldb.Get_DataTable("exec Greef_menu_Like_Class_Index '1.0'");
TreeNode mynode = new TreeNode();
mynode.Text = "网站后台管理";
mynode.NavigateUrl = "http://www.baidu.com";
mynode = addSubNode(mynode, mysdt);
TreeView1.Nodes.Add(mynode);