C# 里TreeView绑定数据库实现分类
-
- SqlConnection con = new SqlConnection("server=127.0.0.1\\sqlexpress;uid=sa;");
- con.Open();
- con.ChangeDatabase("STggggg");
- SqlCommand cmd = new SqlCommand("select * from 产品树 where NodeType='f'", con);
-
- SqlDataAdapter sda = new SqlDataAdapter(cmd);
- DataSet ds = new DataSet();
- try
- {
- sda.Fill(ds);
- }
- catch
- {
- }
- finally
- {
- cmd = null;
- con.Close();
- }
-
-
- TreeNode tn = new TreeNode();
- tn.Text = "所有产品";
- tn.Name = "0";
- tn.Tag = "0";
- tn.ImageIndex = 0;
- tn.SelectedImageIndex = 0;
- tv.Nodes.Add(tn);
- tv.SelectedNode = tv.TopNode;
-
- if (ds != null)
- {
- foreach (DataRow dr in ds.Tables[0].Rows)
- {
- tn = new TreeNode();
- tn.Text = dr["Product"].ToString();
- tn.Name = dr["CateID"].ToString();
- tn.Tag = dr["RootID"].ToString();
- tn.ImageIndex = 1;
- tn.SelectedImageIndex = 1;
-
- if (dr["CateID"].ToString() == dr["RootID"].ToString())
- {
-
- tv.SelectedNode = tv.TopNode;
- }
- else
- {
-
- if (tv.SelectedNode.Name != dr["ParentID"].ToString())
- {
- TreeNode[] tn_temp = tv.Nodes.Find(dr["ParentID"].ToString(), true);
- if (tn_temp.Length > 0)
- {
- tv.SelectedNode = tn_temp[0];
- }
- }
- }
- tv.SelectedNode.Nodes.Add(tn);
- }
-
- tv.SelectedNode = tv.TopNode;
-
原文地址:https://www.cnblogs.com/zhangtao/p/1441983.html