动态绑定treeview

View Code

  1 递归绑定：  DataSet ds = new DataSet();
  2             ds = c.TreeView(Sql);
  3             DataView dr1 = new DataView();
  4             dr1.Table = ds.Tables[0];
  5             foreach (DataRowView drv1 in dr1)
  6             {
  7                 TreeNode tn1 = new TreeNode();
  8                 获取编号
  9                 tn1.Tag = drv1["RP_Code"].ToString();
 10                 获取名称
 11                 tn1.Text = drv1["RP_Name"].ToString();
 12                 添加根级目录
 13                 treeView1.Nodes.Add(tn1);
 14                 tn1.Expand();
 15                 //查找编号长度为3选项——二级
 16                 string SqlP = "select * from YXL_TreeViewInfo where LEN(RP_Code)=3 ";
 17                 ds = c.TreeView(SqlP);
 18                 DataView dr2 = new DataView();
 19                 dr2.Table = ds.Tables[0];
 20                 foreach (DataRowView drv2 in dr2)
 21                 {
 22                     TreeNode tn2 = new TreeNode();
 23                     tn2.Tag = drv2["RP_Code"].ToString();
 24                     tn2.Text = drv2["RP_Name"].ToString();
 25                     //图片
 26                     tn2.ImageIndex = 1;
 27                     tn1.Nodes.Add(tn2);
 28 
 29                     //查找编号长度为3选项——三级
 30                     string SqlC = "select * from YXL_TreeViewInfo where RP_Code like '" + tn2.Tag + "%' and LEN(RP_Code)=6";
 31                     ds = c.TreeView(SqlC);
 32                     DataView dv3 = new DataView();
 33                     dv3.Table = ds.Tables[0];
 34                     foreach (DataRowView drv3 in dv3)
 35                     {
 36                         TreeNode tn3 = new TreeNode();
 37                         tn3.Tag = drv3["RP_Code"].ToString();
 38                         tn3.Text = drv3["RP_Name"].ToString();
 39                         tn3.ToolTipText = drv3["TableName"].ToString();
 40 
 41                         //若有下级目录，对应其他图片
 42                         if (tn3.Tag.ToString() == "002001" || tn3.Tag.ToString() == "002002" || tn3.Tag.ToString() == "007001" || tn3.Tag.ToString() == "007002" || tn3.Tag.ToString() == "007003" || tn3.Tag.ToString() == "007004")
 43                         {
 44                             tn3.ImageIndex = 3;
 45                         }
 46                         else
 47                         {
 48                             tn3.ImageIndex = 2;
 49                             tn3.SelectedImageIndex = 2;
 50                         }
 51                         tn2.Nodes.Add(tn3);
 52                         //查找编号长度为3选项——四级
 53                         string SqlCY = "select * from YXL_TreeViewInfo where RP_Code like '" + tn3.Tag + "%' and LEN(RP_Code)=9";
 54                         ds = c.TreeView(SqlCY);
 55                         DataView dv4 = new DataView();
 56                         dv4.Table = ds.Tables[0];
 57                         foreach (DataRowView drv4 in dv4)
 58                         {
 59                             TreeNode tn4 = new TreeNode();
 60                             tn4.Tag = drv4["RP_Code"].ToString();
 61                             tn4.Text = drv4["RP_Name"].ToString();
 62                             tn4.ToolTipText = drv4["TableName"].ToString();
 63                             tn4.ImageIndex = 2;
 64                             tn4.SelectedImageIndex = 2;
 65                             tn3.Nodes.Add(tn4);
 66 
 67                         }
 68                     }
 69                 }
 70 
 71 用这种方法属于很死的方法。当添加更多的子级时，需要手动再添加。可以点击根节点，动态绑定。
 72 
 73 DataSet ds = new DataSet();
 74             ds = server.ExecSqlForDataSet(Sql);
 75 
 76             DataView dr1 = new DataView();
 77             dr1.Table = ds.Tables[0];
 78 
 79             foreach (DataRowView drv1 in dr1)
 80             {
 81 
 82                 TreeNode tn1 = new TreeNode();       //实例化节点
 83 
 84                 tn1.Tag = drv1["RP_Code"].ToString(); //获取编号
 85 
 86                 tn1.Text = drv1["RP_Name"].ToString();//获取名称
 87 
 88                 tn1.ImageIndex = Convert.ToInt16(drv1["ImageIndex"].ToString());//获取图片索引
 89 
 90                 tn1.SelectedImageIndex = Convert.ToInt16(drv1["SelectedImageIndex"].ToString());//被选中图片索引
 91 
 92                 tn1.ToolTipText = drv1["TableName"].ToString();//表名
 93 
 94                 if (p_Tn.Nodes.Count == 0)//判断是否存在
 95                 {
 96                     p_Tn.Nodes.Add(tn1);//没有子节点，父级目录添加子级目录
 97                 }
 98                 else
 99                 {
100                     bool IsNode = false;
101                     //存在子节点
102                     foreach (TreeNode item in p_Tn.Nodes)
103                     {
104                         if (item.Tag.Equals(tn1.Tag))
105                         {
106                             IsNode = true;
107                         }
108                     }
109                     if (IsNode == false)
110                     {
111                         p_Tn.Nodes.Add(tn1);
112                     }
113                 }

 

转载于:https://www.cnblogs.com/bulebule/archive/2013/01/11/2178761.html