asp.net中treeView(无限级tree)--源码--调试成功

只把.cs文件的代码写出来了,页面中定义一个treeView1就可以了~   

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Session["userName"] != null)
            {
                showlist();
            }
            else
            {
                Response.Write("<script>alert('请先登录!');location.href='login.aspx';</script>");
            }
           
        }
    }
    private void showlist(){
   //添加根节点   
            TreeView1.Nodes.Clear();
            TreeNode node = new TreeNode();
            node.Text = Session["userName"].ToString();
            node.Target = "0";
            node.Expanded = true;
            TreeView1.Nodes.Add(node);
            treeShow(0, node);
            TreeView1.DataBind();     
}
    //递归
private void treeShow(int parterid,TreeNode treenode){
   DataSet ds=returnDataset(parterid);
   if (ds!=null)
   {
    for(int i=0;i<ds.Tables[0].Rows.Count;i++)
    {
     TreeNode node=new TreeNode();
     if (!ds.Tables[0].Rows[i]["NodeName"].ToString().Equals(treenode.Value))
     {
         node.Target = ds.Tables[0].Rows[i]["nodeID"].ToString();
         node.Text = ds.Tables[0].Rows[i]["NodeName"].ToString();
         treenode.ChildNodes.Add(node);
         node.Expanded = true;
         DataSet ds2 = returnDataset(Int32.Parse(ds.Tables[0].Rows[i]["Nodeid"].ToString()));
         if (ds2.Tables[0].Rows.Count > 0)
         {
             treeShow(Int32.Parse(ds.Tables[0].Rows[i]["Nodeid"].ToString()), node);
         }
     }
    
    }
   }
}

private DataSet returnDataset(int parterid){
      SqlConnection conn = new SqlConnection();
      conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DB_PhotoManagerConnectionString"].ConnectionString;
      String userName = Session["userName"].ToString();
      SqlCommand cmd;
   DataSet ds=new DataSet();
   try
   {
    conn.Open();
    cmd = new SqlCommand("select * from tree where parid=" + parterid +"order by creatTime asc", conn);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    sda.Fill(ds);
   }
   catch(Exception ex)
   {
    Response.Write(ex.ToString());
    Response.End();
   }
   finally{
    conn.Dispose();
   }
   return ds;
}

posted @ 2009-02-28 19:37  perfectMan  阅读(815)  评论(1)    收藏  举报