今天学习的时候自己写的无限级分类

EM_idEM_nameEM_sidEM_supperid1IT设备012办公用品023联想主机104联想显示器105启天M8200306启天M8000307联想19寸408联想17寸409联想19寸液晶7010联想19寸纯平70EM_Type

 

结果

//获取第一级节点 DataSet ds = cc.GetDS("select * from EM_Type where EM_sid = 0 and EM_supperid<>0", "type"); TreeNode tree1 = new TreeNode("设备分类"); TreeView1.Nodes.Add(tree1); for (int i = 0; i < ds.Tables["type"].Rows.Count; i++) { TreeNode tree2 = new TreeNode(ds.Tables["type"].Rows[i][1].ToString(), ds.Tables["type"].Rows[i][0].ToString()); //tree1.ChildNodes.Add(tree2); treeV(tree2); ///循环获取2级以下的节点 } private void treeV(TreeNode parent) { DataSet ds = cc.GetDS("select * from EM_Type where EM_sid =" + parent.Value, "Types"); Response.Write("select * from EM_Type where EM_sid =" + parent.Value+"<br />"); if (ds.Tables["Types"].Rows.Count > 0) { for (int i = 0; i < ds.Tables["Types"].Rows.Count; i++) { TreeNode child = new TreeNode(ds.Tables["Types"].Rows[i][1].ToString(), ds.Tables["Types"].Rows[i][0].ToString()); parent.ChildNodes.Add(child); treeV(child); } } }