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);
    }
}