递归问题~~

Question

谁有现成下拉递归的例子发一个我，谢谢，要ACCESS数据库的，本机没装~例：http://m.99081.com/stulife/Article.aspx?id=4fa46745-5cd6-40f1-ad64-25e6522abebf
这个一直没调试出来~

Answer 1

不好意思，email忘了  [email protected]

Answer 2

你给的那个链接地址上的例子不就是想现成的吗。
private void BindDrpClass()
10    {
11         Bll.Class classSystem = new Bll.Class();
12         DataTable dt = classSystem.GetClassList("").Tables[0];         //将数据放入dt中13         ddlClass.Items.Clear();
14         ddlClass.Items.Add(new ListItem("添加根栏目","0"));
15         DataRow[] drs = dt.Select("ParentID= " + 0);
16
17        foreach (DataRow dr in drs)
18        {
19            string classid = dr["ClassID"].ToString();
20            string classname = dr["ClassName"].ToString();
21            //顶级分类显示形式
22             classname = "╋" + classname;
23
24             ddlClass.Items.Add(new ListItem(classname, classid));
25            int sonparentid = int.Parse(classid);
26            string blank = "├";
27            //递归子分类方法
28             BindNode(sonparentid, dt, blank);
29         }
30         ddlClass.DataBind();
31     }
32    //绑定子分类
33    private void BindNode(int parentid, DataTable dt, string blank)
34    {
35         DataRow[] drs = dt.Select("ParentID= " + parentid);
36
37        foreach (DataRow dr in drs)
38        {
39            string classid = dr["ClassID"].ToString();
40            string classname = dr["ClassName"].ToString();
41
42             classname = blank + classname;
43             ddlClass.Items.Add(new ListItem(classname, classid));
44
45            int sonparentid = int.Parse(classid);
46            string blank2 = blank + "─";
47
48             BindNode(sonparentid, dt, blank2);
49         }
50     }

Answer 3

private void FatherNodeBinder() 
    { 
        TreeView1.Nodes.Clear(); 
        DataTable TreeFather = UserInfoManager.MasterPageTreeView(0); 
        foreach (DataRow dr in TreeFather.Rows) 
        { 
            int MenId = Convert.ToInt32(dr["NodeId"].ToString()); 
            string MenName = dr["DisplayName"].ToString(); 
            TreeNode FatherTreeNode = new TreeNode(); 
            FatherTreeNode.Value = MenId.ToString(); 
            FatherTreeNode.Text = MenName; 
            FatherTreeNode.ImageUrl = "images/menuclose.gif"; 
            TreeViewBind(MenId, FatherTreeNode); 
            TreeView1.Nodes.Add(FatherTreeNode); 
        } 
    }     public void TreeViewBind(int NodeId,TreeNode TwoTreeNode) 
    { 
        DataTable TreeFather = UserInfoManager.MasterPageTreeView(NodeId); 
        foreach (DataRow dr in TreeFather.Rows) 
        { 
            int TMenId = Convert.ToInt32(dr["NodeId"].ToString()); 
            string TMenName = dr["DisplayName"].ToString(); 
            string TMenUrl =ResolveUrl(dr ["NodeURL"].ToString()); 
            TreeNode TN = new TreeNode(); 
            TN.Value = TMenId.ToString(); 
            TN.Text = TMenName; 
            TN.NavigateUrl = TMenUrl; 
            TN.ImageUrl = "images/CloseTree.gif"; 
            TreeViewBind(TMenId, TN); 
            TwoTreeNode.ChildNodes.Add(TN); 
        } 
    }

Answer 4

return DAL.SqlHelper.ExecuteDataset(DAL.SqlHelper.ConnString, CommandType.Text, strSql.ToString());主要是这句不知道啥意思~~，帮忙解释~

Answer 5

SqlHelper而已
DAL.SqlHelper.ConnString:数据库链接字符串
CommandType.Text：以文本的形式访问数据库
strSql.ToString()：sql语句
返回值：dataset

Answer 6

 private void BindJG()
    {
        DataSet ds = new DataSet();        DataTable dtb = ds.Tables[0];
        TreeNode root = new TreeNode();
        root.Value = "0";
        root.Text = "";
        root.ImageUrl = "../images/folder.gif";
        root.Expanded = true;
        this.TreeView1.Nodes.Add(root);
        initTree(dtb, "", root);
        this.TreeView1.ExpandAll();
    }
protected void initTree(DataTable dt, string nFatherid, TreeNode fatherNode)
    {
        DataView dv = new DataView(dt);        if (nFatherid == "")
            dv.RowFilter = "depth='1'";
        else
            dv.RowFilter = "shangjjgbh='"+nFatherid+"'";
        foreach (DataRowView Row in dv)
        {
            TreeNode node = new TreeNode();
            if (fatherNode.Value == "0")
            {
               node.Value = Row["BH"].ToString();
               node.Text = Row["mc"].ToString();
               node.NavigateUrl = "";
               node.ImageUrl = "../images/folder.gif";
               fatherNode.ChildNodes.Add(node);
               initTree(dt, Row["BH"].ToString(), node);
            }
            else
            {
                node.Text = Row["mc"].ToString();
                node.Value = Row["BH"].ToString();
                node.ImageUrl = "../images/jg.gif";
                fatherNode.ChildNodes.Add(node);           }
        }
    }
实例很多，搜索下。参考

Answer 7

function a()
{
a();
}