开发者

Windows Forms application that loads a tree from a database table, and displays it in a TreeView object?

This is the Cod开发者_Python百科e I have so far, I am having problem with the loop, I don't get it.

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)
        {

        }

    }
}


This is an example of a recursive method:

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜