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

问题描述

我有一个包含以下字段的数据库表(名为主题):

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

1. 主题ID
2. 姓名
3. 父 ID

通过使用它们，我想在 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屋！