急！！！asp.net + c# 怎么实现产品的无限级分类?????????????????????????

Question

要有级别关系,比如：
  A
     A1
     A2
           A21
  B
     B1
     B2
  ............  X  
     X1
          X11

Answer 1

常见的有两种办法
典型的
设计一个树形结构表
ID PID ClassName

Answer 2

void  creat_node(string
name,Microsoft.Web.UI.WebControls.TreeNode  t1,string  number)
        {
            //定义一个新的结点            Microsoft.Web.UI.WebControls.TreeNode  t2=new
Microsoft.Web.UI.WebControls.TreeNode();
            t2.ID=number;
            t2.Text=name;
            //判断是否为根结点
            TreeView1.ExpandedImageUrl="images/Depart03.bmp";
            if(t1.ID.Trim()=="###")
            {
                TreeView1.Nodes.Add(t2);
                t2.ImageUrl="images/Depart01.bmp";
            }
            else
            {
                t1.Nodes.Add(t2);
                   t2.ImageUrl="images/Depart01.bmp";
                t1.ImageUrl="images/Depart02.bmp";
            }
            //取得这个结点的所有子结点，利用递归自动生成
            string mySelectQuery = "SELECT ParentID, ID,Name FROM table1
where  ParentID='" + number +"'";
            string MyConnString="provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+Server.MapPath(".")+"/dt/mydata.mdb";
            OleDbConnection myConnection = new
OleDbConnection(MyConnString);
            OleDbCommand myCommand = new
OleDbCommand(mySelectQuery,myConnection);
            myConnection.Open();
            OleDbDataReader myReader;
            myReader = myCommand.ExecuteReader();
            while (myReader.Read())
            {
                creat_node(myReader.GetString(2),t2,myReader.GetString(1));            }
            myReader.Close();
            myConnection.Close();        }    private void CreateProviderTreeBtn_Click(object sender,
System.EventArgs e)
        {
            Microsoft.Web.UI.WebControls.TreeNode  t1=new
Microsoft.Web.UI.WebControls.TreeNode();
            creat_node("",t1,"###");