treeview绑定类别

  public void gettree()
    {
        str = "select * from good_type where p_id=0";
        SqlConnection conn = db.getconn();
        SqlDataAdapter sda = new SqlDataAdapter(str, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        DataView dv = ds.Tables[0].DefaultView;
        foreach (DataRowView dr in dv)
        {
            TreeNode tn = new TreeNode();
            tn.Text = dr["p_type"].ToString();
            tn.Value = dr["id"].ToString();
            tn.NavigateUrl = "Products.aspx?id=" + dr["id"].ToString().Trim();
            tn.Expanded = true;
            this.TreeView1.Nodes.Add(tn);
            this.addchild(tn);
        }
    }
    public void addchild(TreeNode tn)
    {
        str = "select * from good_type where p_id=" + tn.Value.Trim();
        SqlConnection conn = db.getconn();
        SqlDataAdapter sda = new SqlDataAdapter(str, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        DataView dv = ds.Tables[0].DefaultView;
        foreach (DataRowView dr in dv)
        {
            TreeNode tnc = new TreeNode();
            tnc.Text = dr["p_type"].ToString();
            tnc.Value = dr["id"].ToString();
            tnc.NavigateUrl ="Products.aspx?id="+dr["id"].ToString().Trim();
            tn.ChildNodes.Add(tnc);

            this.addchild(tnc);//递归调用

        }
    }