从数据库填充的TreeView [英] Populate TreeView from DataBase

问题描述

我有一个数据库表（命名为主题），其中包括以下字段：

I have a database table (named Topics) which includes these fields :

1. topicId


2. 名称


3. parentId的

和使用他们，我想填充在C＃中一个TreeView。我该怎么做？

and by using them I wanna populate a TreeView in c#. How can I do that ?

在此先感谢...

推荐答案

这可能会是这样的。给一些更详细的为你想，如果你需要更多的工作要做什么。

It will probably be something like this. Give some more detail as to what exactly you want to do if you need more.

//In Page load
foreach (DataRow row in topics.Rows)
{
    TreeNode node = new TreeNode(dr["name"], dr["topicId"])
    node.PopulateOnDemand = true;

     TreeView1.Nodes.Add(node);
 }
 ///
 protected void PopulateNode(Object sender, TreeNodeEventArgs e)
 {
     string topicId = e.Node.Value;
     //select from topic where parentId = topicId.
     foreach (DataRow row in topics.Rows)
     {
         TreeNode node = new TreeNode(dr["name"], dr["topicId"])
         node.PopulateOnDemand = true;

         e.Node.ChildNodes.Add(node);
     }

 }

这篇关于从数据库填充的TreeView的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！