Windows 窗体应用程序从数据库表加载树并将其显示在 TreeView 对象中？

Question

这是我到目前为止的代码，我的循环有问题，我不明白。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication11_TreeView
{
    public partial class Form1 : Form
    {
        OleDbConnection dbConn;
        public Form1()
        {
            InitializeComponent();
            string connStr = @"Provider=Microsoft.ACE.OLEDB.12.0; DataSource=PartsTree.accdb";
            try
            {
                dbConn = new OleDbConnection(connStr);
                dbConn.Open();
                AddChildNodes(treeView1.Nodes, 0);
                dbConn.Close();
                dbConn.Dispose();
            }
            catch (OleDbException e)
            {
                MessageBox.Show(e.Message, "Exception!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                Application.Exit();
            }
        }

        private void AddChildNodes(TreeNodeCollection nodes, int parent)
        {
            string queryStr = "SELECT ID, parent_ID, description";
            queryStr += "FROM parts Where parent_ID";
            queryStr += (0 == parent ? "IS NULL;" : "=?");
            OleDbCommand dbCmd = dbConn.CreateCommand();
            dbCmd.CommandText = queryStr;

            if (0 != parent)
            {
                OleDbParameter parameter = dbCmd.Parameters.Add("@InputParm", OleDbType.Integer);
                parameter.Value = parent;
            }

            using (OleDbDataReader rdr = dbCmd.ExecuteReader())
            {
                while (rdr.Read())
                {

                }
                rdr.Close();
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

    }
}

Answer 1

这是递归方法的示例：

//Link this to the AfterCheck property
private void treeViewCheckedChange(Object sender, TreeViewEventArgs e)
{
    TreeNode node = (TreeNode)e.Node;
    checkedNodes(node);
}

//Recursive method checks child, and then calls itself
private void checkedNodes(TreeNode parent)
{
    foreach (TreeNode child in parent.Nodes)
    {
        child.Checked = parent.Checked;
        checkedNodes(child);
    }
}