treeview绑定求助，treeview绑定数据

数据库信息如何绑定到TreeView和SiteMapPath控件中

给个完成的类 /// <summary> /// 绑定TreeView /// </summary> /// <param name="nodes">节点名称</param> /// <param name="parentid">父节点编号</param> public void MenuTvBind(TreeNodeCollection nodes, string parentid) { TreeNode NewNode;//新节点 DataRow[] rows = ds.Tables[0].Select("parent_id=" + parentid);//得到父节点的子节点 foreach (DataRow dr in rows) { NewNode = new TreeNode(dr["menu_name"].ToString(), dr["id"].ToString()); NewNode.ToolTip = dr["menu_name"].ToString(); NewNode.ImageUrl = "../../" + dr["image_path"].ToString(); NewNode.SelectAction = TreeNodeSelectAction.SelectExpand; NewNode.Expanded = true; NewNode.Selected = false; if (dr[4].ToString() == "1") { NewNode.Checked = true; } nodes.Add(NewNode); MenuTvBind(NewNode.ChildNodes, dr["id"].ToString());//递归生成分类树 } }

treeview绑定SQL

我这里有一个Json递归的代码 不过和TreeView是互通的 稍作修改就应该可以啦。

。

。

private object[] BindChildTreeNode(string pid) { string sql = "select * from dbo.ProgramModuleCodes where ParentProgramModuleNr=" + pid; DataTable table = DBHelper.GetDataTable(sql); if (table != null &amp;&amp; table.Rows.Count &gt; 0) { object[] objects = new object[table.Rows.Count]; int i = 0; foreach (DataRow item in table.Rows) { string id = item[0].ToString(); objects[i] = NodeAdd(id, item[1].ToString(), true, true, pid, ModuleCheckState.Substring(int.Parse(id), 1), true, true, true, BindChildTreeNode(id, 2)); i++; } } return objects; }

求助，treeview绑定数据

private TreeNode FindNode(TreeNode tnParent, string strValue) { TreeNode treeNode2 = new TreeNode(); string venueCode = ""; if (tnParent == null) return null; if (tnParent.Value == strValue) return tnParent; tnParent.Expand(); TreeNode tnRet = null; foreach (TreeNode tn in tnParent.ChildNodes) { //获得节点Value if (venueCode == "") { //记录节点 treeNode2 = tn; venueCode = tn.Value; } else { //当选择节点发生变化时 if (venueCode != tn.Value) { treeNode2.Collapse(); venueCode = tn.Value; treeNode2 = tn; } } tnRet = FindNode(tn, strValue); if (tnRet != null) break; } return tnRet; } private DataSet Getdata(string pid) //在这里传入一个parentteacherid { //DataSet ds = 根据传入的ID查找数据; //return ds; //返回含有parentteacherid的数据 } private void BindTreeView(, string pid) { DataSet ds = Getdata(pid); if (ds.Tables[0].Rows.Count &gt; 0) { for (int i = 0; i &lt; ds.Tables[0].Rows.Count; i++) { TreeNode node = new TreeNode(ds.Tables[0].Rows[i]["teacherid节点描述"].ToString(), ds.Tables[0].Rows[i] ["teacherid"].ToString()); //这是在找数据库中的节点 .Nodes.Add(node); //把这个节点添加到控件中 node.SelectAction = TreeNodeSelectAction.Expand; BindNode(node); } } } private void BindNode(TreeNode nd) //就是一个递归的开始 遍历根节点下面的子节点 { DataSet ds = Getdata(nd.Value); for (int i = 0; i &lt; ds.Tables[0].Rows.Count; i++) { TreeNode node = new TreeNode(); node.Text = ds.Tables[0].Rows[i]["teacherid节点描述"].ToString(); //节点文本老师名啊，学生名等 node.Value = ds.Tables[0].Rows[i]["teacherid"].ToString(); nd.ChildNodes.Add(node); node.SelectAction = TreeNodeSelectAction.Expand; BindNode(node); } } 调用方法：BindTreeView(TreeView1, 0) 假设你的根节点ID=0 细节问题你自己再改改