Windows Forms应用程序可以从数据库表中加载树,并在TreeView对象中显示它?
|
到目前为止,这是我的代码,我在循环中遇到问题,我不明白。
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)
{
}
}
}
没有找到相关结果
已邀请:
1 个回复
驮帽俺篮号