TreeView控件与SQL数据库的应用(遍历算法)
开发环境:WinXP SP3,VS2008,SQL2000
TreeView控件与SQL数据库的应用(遍历算法)
(数据与TreeView的绑定及Treeview的增加、删除、修改、遍历等数据库的操作)
这个是数据库连接及一些操作数据库的方法,文件:SqlManager.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;
namespace TreeViewText
{
class SqlManager
{
SqlConnection conn;
string strConn;
public SqlManager()
{
strConn = @"Data Source = .;Initial Catalog = TreeView; Integrated Security = SSPI; Persist Security Info = False; User ID = sa; Password = sa";
conn = new SqlConnection(strConn);
}
public DataSet GetDataSet()
{
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(querySqlCmd, conn);
try
{
conn.Open();
sda.Fill(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "获取数据失败!");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return ds;
}
public DataSet GetDataSet(string sqlCmd)
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlCmd, conn);
try
{
conn.Open();
da.Fill(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "获取数据失败!");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return ds;
}
public void RunSqlCommand(string sqlCmd)
{
SqlCommand cmd = new SqlCommand(sqlCmd, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库失败!");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
private string m_querySqlCmd;
#region 获取SQL语句
public string querySqlCmd
{
get
{
if (m_querySqlCmd == null)
{
return "select * from TreeNode";
}
return querySqlCmd;
}
set
{
m_querySqlCmd = value;
}
}
#endregion
}
}
主窗体:Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace TreeViewText
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
//TreeNode treeNode1 = new TreeNode("节点1", new TreeNode[] { treeNode4, treeNode5 });
//treeView1.Nodes.AddRange(new TreeNode[] { treeNode1 });
}
#region TreeView节点编辑(没有修改数据库)
private void btnEdit_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
if (!treeView1.SelectedNode.IsEditing)
treeView1.SelectedNode.BeginEdit();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
treeView1.SelectedNode.Remove();
}
private void btnAddNode_Click(object sender, EventArgs e)
{
TreeNode treeNodeTemp = new TreeNode(GetNodeText());
if (treeView1.Nodes.Count > 0)
{
if (treeView1.SelectedNode != null)
{
if (treeView1.SelectedNode.Parent != null)
treeView1.SelectedNode.Parent.Nodes.Add(treeNodeTemp);
else
treeView1.Nodes.Add(treeNodeTemp);
}
}
else
{
treeView1.Nodes.Add(treeNodeTemp);
}
}
private void btnAddChild_Click(object sender, EventArgs e)
{
TreeNode treeNodeTemp = new TreeNode(GetNodeText());
if (treeView1.SelectedNode != null)
{
treeView1.SelectedNode.Nodes.Add(treeNodeTemp);
}
}
#region 获取文本框文本信息
/// <summary>
/// 获取文本框文本信息
/// </summary>
/// <returns>string</returns>
private string GetNodeText()
{
if (!String.IsNullOrEmpty(tbNodeName.Text.Trim()))
return tbNodeName.Text.Trim();
return "TreeNode";
}
#endregion
#endregion
/// <summary>
/// 查询数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnQuery_Click(object sender, EventArgs e)
{
SqlManager sqlManager = new SqlManager();
dataGridView1.DataSource = sqlManager.GetDataSet(sqlManager.querySqlCmd).Tables[0];
//清空TreeView的内容
treeView1.Nodes.Clear();
//递归函数,0为根节点的父节点ParentID的值
AddTreeView(0, (TreeNode)null);
//非递归(两层分类显示)
//ShowTreeView((TreeNode)null);
//展开所有树节点
//treeView1.Expand();
}
/// <summary>
/// 退出程序
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}
#region 获得数据库信息放入TreeView中 (递归)
private void AddTreeView(int ParentID, TreeNode parentNode)
{
SqlManager sqlManager = new SqlManager();
DataView dataTree = new DataView(sqlManager.GetDataSet().Tables[0]);
string filter = "ParentID = " + ParentID;
dataTree.RowFilter = filter;
foreach (DataRowView row in dataTree)
{
TreeNode node = new TreeNode();
//处理根节点
if (parentNode == null)
{
node.Name = row["ID"].ToString();
node.Text = row["Name"].ToString();
treeView1.Nodes.Add(node);
AddTreeView(Int32.Parse(row["ID"].ToString().Trim()), node);
}
//处理子节点
else
{
node.Name = row["ID"].ToString();
node.Text = row["Name"].ToString();
parentNode.Nodes.Add(node);
AddTreeView(Int32.Parse(row["ID"].ToString().Trim()), node);
}
}
}
#endregion
#region 获得数据库信息放入TreeView中 (非递归函数,根据Category来分类,仅支持两层分类)
/*private void ShowTreeView(TreeNode pNode)
{
treeView1.Nodes.Clear();
SqlManager sqlManager = new SqlManager();
DataView dataTree = new DataView(sqlManager.GetDataSet("select distinct Category from TreeNode").Tables[0]);
foreach (DataRowView row in dataTree)
{
TreeNode node = new TreeNode();
node.Text = row["Category"].ToString();
treeView1.Nodes.Add(node);
CreateChildNodes(node);
}
}
//获取第二层节点的的数据
private void CreateChildNodes(TreeNode treenode)
{
SqlManager sqlManager = new SqlManager();
DataView dataTree = new DataView(sqlManager.GetDataSet().Tables[0]);
dataTree.RowFilter = "Category = '" + treenode.Text + "'";
foreach (DataRowView row in dataTree)
{
TreeNode node = new TreeNode();
node.Text = row["Name"].ToString();
treenode.Nodes.Add(node);
}
}*/
#endregion
/// <summary>
/// 添加记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
SqlManager sqlManager = new SqlManager();
string insertSqlCmd = String.Empty;
if (TextBoxValidator(tbParentID))
{
MessageBox.Show("请输入ParentID(父节点)", "提示");
tbParentID.Focus();
}
else if (TextBoxValidator(tbName))
{
MessageBox.Show("请输入Name(物品名称)", "提示");
tbName.Focus();
}
else if (TextBoxValidator(tbCategory))
{
MessageBox.Show("请输入Category(物品类别)", "提示");
tbCategory.Focus();
}
else
{
insertSqlCmd = "insert into TreeNode (ParentID,Name,Category) values (" + tbParentID.Text.Trim() + ",'" + tbName.Text.Trim() + "','" + tbCategory.Text.Trim() + "');";
sqlManager.RunSqlCommand(insertSqlCmd);
dataGridView1.DataSource = sqlManager.GetDataSet(sqlManager.querySqlCmd).Tables[0];
treeView1.Nodes.Clear();
AddTreeView(0, (TreeNode)null);
//treeView1.ExpandAll();
}
}
/// <summary>
/// 修改记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnModify_Click(object sender, EventArgs e)
{
SqlManager sqlManager = new SqlManager();
string updateSqlCmd = String.Empty;
if (TextBoxValidator(tbID))
MessageBox.Show("请先选择一个产品", "提示");
else if (TextBoxValidator(tbParentID))
{
MessageBox.Show("请输入ParentID(父节点)", "提示");
tbParentID.Focus();
}
else if (tbID.Text.Trim() == tbParentID.Text.Trim())
{
MessageBox.Show("ID(产品ID)不能与ParentID(父节点)相同,请重新输入", "提示");
tbParentID.Focus();
}
else if (TextBoxValidator(tbName))
{
MessageBox.Show("请输入Name(物品名称)", "提示");
tbName.Focus();
}
else if (TextBoxValidator(tbCategory))
{
MessageBox.Show("请输入Category(物品类别)", "提示");
tbCategory.Focus();
}
else
{
updateSqlCmd = "update TreeNode set ParentID = " + tbParentID.Text.Trim() + ",Name = '" + tbName.Text.Trim() + "',Category = '" + tbCategory.Text.Trim() + "' where ID = " + tbID.Text.Trim() + ";";
sqlManager.RunSqlCommand(updateSqlCmd);
dataGridView1.DataSource = sqlManager.GetDataSet(sqlManager.querySqlCmd).Tables[0];
treeView1.Nodes.Clear();
AddTreeView(0, (TreeNode)null);
//treeView1.ExpandAll();
}
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRemove_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
{
TreeNode node = treeView1.SelectedNode;
//删除所选节点及其所有子节点
DeleteTreeNode(node);
SqlManager sqlManager = new SqlManager();
dataGridView1.DataSource = sqlManager.GetDataSet(sqlManager.querySqlCmd).Tables[0];
}
}
/// <summary>
/// 删除所选节点及其所有子节点 (通过遍历节点删除对应的数据库数据)
/// </summary>
/// <param name="parentNode"></param>
private void DeleteTreeNode(TreeNode parentNode)
{
/***************方法一:删除选中节点及其所有子节点***************/
int childCount = parentNode.Nodes.Count;
for (int i = 0; i < childCount; i++)
{
TreeNode childNode = parentNode.Nodes[0];
if (childNode.Nodes.Count > 0)
{
DeleteTreeNode(childNode);
}
else
{
DeleteNodeData(childNode);
childNode.Remove();
}
}
if (parentNode.Nodes.Count == 0)
{
DeleteNodeData(parentNode);
parentNode.Remove();
}
/***************方法二:删除选中节点及其所有子节点***************/
//TreeNodeCollection treeNodeCollection = parentNode.Nodes;
//int count = treeNodeCollection.Count;
//for (int i = 0; i < count; i++)
//{
// TreeNode node = treeNodeCollection[0];
// if (node.Nodes.Count > 0)
// {
// DeleteTreeNode(node);
// }
// else
// {
// DeleteNodeData(node);
// node.Remove();
// }
//}
//if (treeNodeCollection.Count == 0)
//{
// DeleteNodeData(parentNode);
// parentNode.Remove();
//}
}
/// <summary>
/// 方法三:删除选中节点的所有子节点(选中的主节点不会被删除)
/// </summary>
/// <param name="parentNode"></param>
private void DeleteTreeNodeWithoutPareNode(TreeNode parentNode)
{
int count = parentNode.Nodes.Count;
for (int i = 0; i < count; i++)
{
TreeNode node = parentNode.Nodes[0];
DeleteTreeNodeWithoutPareNode(node);
DeleteNodeData(node);
node.Remove();
}
}
/// <summary>
/// 将要删除的节点传给该函数,利用节点的Name属性(ID)删除数据库数据
/// </summary>
/// <param name="node"></param>
private void DeleteNodeData(TreeNode node)
{
SqlManager sqlManager = new SqlManager();
string deleteSqlCmd = String.Empty;
deleteSqlCmd = "delete from TreeNode where ID = " + node.Name;
sqlManager.RunSqlCommand(deleteSqlCmd);
}
/// <summary>
/// 检查TextBox的Text属性是否为空或没有字符
/// </summary>
/// <param name="sender"></param>
/// <returns>true/false</returns>
private bool TextBoxValidator(object sender)
{
if (String.IsNullOrEmpty(((TextBox)sender).Text))
return true;
else
return false;
}
/// <summary>
/// TreeView中节点选择事件,用来将数据放入TextBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
string treeNodeID = treeView1.SelectedNode.Name;
SqlManager sqlManager = new SqlManager();
DataTable dt;
dt = sqlManager.GetDataSet("select * from TreeNode where ID = '" + treeNodeID + "'").Tables[0];
if (dt.Rows.Count > 0)
{
tbID.Text = dt.Rows[0]["ID"].ToString();
tbParentID.Text = dt.Rows[0]["ParentID"].ToString();
tbName.Text = dt.Rows[0]["Name"].ToString();
tbCategory.Text = dt.Rows[0]["Category"].ToString();
}
}
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
if (dataGridView1.SelectedCells.Count != 0)
{
tbID.Text = dataGridView1.CurrentRow.Cells["ID"].Value.ToString();
tbParentID.Text = dataGridView1.CurrentRow.Cells["ParentID"].Value.ToString();
tbName.Text = dataGridView1.CurrentRow.Cells["Name"].Value.ToString();
tbCategory.Text = dataGridView1.CurrentRow.Cells["Category"].Value.ToString();
}
}
private void 展开下一层节点ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
{
treeView1.SelectedNode.Expand();
}
}
private void 展开所有节点ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
{
treeView1.SelectedNode.ExpandAll();
}
}
private void 选中节点的所有子节点ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode != null)
{
TreeNode node = treeView1.SelectedNode;
//删除所选节点的所有子节点
DeleteTreeNodeWithoutPareNode(node);
SqlManager sqlManager = new SqlManager();
dataGridView1.DataSource = sqlManager.GetDataSet(sqlManager.querySqlCmd).Tables[0];
}
}
private void 节点及其所有子节点ToolStripMenuItem_Click(object sender, EventArgs e)
{
btnRemove_Click(null, null);
}
private void treeView1_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
TreeNode treenode = treeView1.GetNodeAt(e.X, e.Y);
if (treenode != null && treenode.Bounds.Contains(e.X, e.Y))
{
treeView1.SelectedNode = treenode;
}
else
{
treeView1.SelectedNode = null;
}
}
}
}
}
Form1.Designer.cs文件:
namespace TreeViewText { partial class Form1 { /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.IContainer components = null; /// <summary> /// 清理所有正在使用的资源。 /// </summary> /// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param> protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows 窗体设计器生成的代码 /// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); this.treeView1 = new System.Windows.Forms.TreeView(); this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components); this.展开树ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.展开所有节点ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.删除ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.节点ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.节点及其所有子节点ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.label1 = new System.Windows.Forms.Label(); this.btnDelete = new System.Windows.Forms.Button(); this.btnAddNode = new System.Windows.Forms.Button(); this.btnAddChild = new System.Windows.Forms.Button(); this.label2 = new System.Windows.Forms.Label(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.btnQuery = new System.Windows.Forms.Button(); this.btnExit = new System.Windows.Forms.Button(); this.btnEdit = new System.Windows.Forms.Button(); this.tbNodeName = new System.Windows.Forms.TextBox(); this.label3 = new System.Windows.Forms.Label(); this.btnModify = new System.Windows.Forms.Button(); this.btnRemove = new System.Windows.Forms.Button(); this.btnAdd = new System.Windows.Forms.Button(); this.tbID = new System.Windows.Forms.TextBox(); this.tbName = new System.Windows.Forms.TextBox(); this.tbCategory = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.tbParentID = new System.Windows.Forms.TextBox(); this.label7 = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.contextMenuStrip1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // treeView1 // this.treeView1.ContextMenuStrip = this.contextMenuStrip1; this.treeView1.HideSelection = false; this.treeView1.LabelEdit = true; this.treeView1.Location = new System.Drawing.Point(12, 24); this.treeView1.Name = "treeView1"; this.treeView1.Size = new System.Drawing.Size(208, 326); this.treeView1.TabIndex = 0; this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect); this.treeView1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.treeView1_MouseDown); // // contextMenuStrip1 // this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.展开树ToolStripMenuItem, this.展开所有节点ToolStripMenuItem, this.删除ToolStripMenuItem}); this.contextMenuStrip1.Name = "contextMenuStrip1"; this.contextMenuStrip1.ShowImageMargin = false; this.contextMenuStrip1.Size = new System.Drawing.Size(130, 70); // // 展开树ToolStripMenuItem // this.展开树ToolStripMenuItem.Name = "展开树ToolStripMenuItem"; this.展开树ToolStripMenuItem.Size = new System.Drawing.Size(129, 22); this.展开树ToolStripMenuItem.Text = "展开下一层节点"; this.展开树ToolStripMenuItem.Click += new System.EventHandler(this.展开下一层节点ToolStripMenuItem_Click); // // 展开所有节点ToolStripMenuItem // this.展开所有节点ToolStripMenuItem.Name = "展开所有节点ToolStripMenuItem"; this.展开所有节点ToolStripMenuItem.Size = new System.Drawing.Size(129, 22); this.展开所有节点ToolStripMenuItem.Text = "展开所有子节点"; this.展开所有节点ToolStripMenuItem.Click += new System.EventHandler(this.展开所有节点ToolStripMenuItem_Click); // // 删除ToolStripMenuItem // this.删除ToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] { this.节点ToolStripMenuItem, this.节点及其所有子节点ToolStripMenuItem}); this.删除ToolStripMenuItem.Name = "删除ToolStripMenuItem"; this.删除ToolStripMenuItem.Size = new System.Drawing.Size(129, 22); this.删除ToolStripMenuItem.Text = "删除节点->"; // // 节点ToolStripMenuItem // this.节点ToolStripMenuItem.Name = "节点ToolStripMenuItem"; this.节点ToolStripMenuItem.Size = new System.Drawing.Size(202, 22); this.节点ToolStripMenuItem.Text = "选中节点的所有子节点"; this.节点ToolStripMenuItem.Click += new System.EventHandler(this.选中节点的所有子节点ToolStripMenuItem_Click); // // 节点及其所有子节点ToolStripMenuItem // this.节点及其所有子节点ToolStripMenuItem.Name = "节点及其所有子节点ToolStripMenuItem"; this.节点及其所有子节点ToolStripMenuItem.Size = new System.Drawing.Size(202, 22); this.节点及其所有子节点ToolStripMenuItem.Text = "选中节点及其所有子节点"; this.节点及其所有子节点ToolStripMenuItem.Click += new System.EventHandler(this.节点及其所有子节点ToolStripMenuItem_Click); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(12, 9); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(41, 12); this.label1.TabIndex = 1; this.label1.Text = "节点:"; // // btnDelete // this.btnDelete.Enabled = false; this.btnDelete.Location = new System.Drawing.Point(113, 370); this.btnDelete.Name = "btnDelete"; this.btnDelete.Size = new System.Drawing.Size(75, 23); this.btnDelete.TabIndex = 16; this.btnDelete.Text = "删除"; this.btnDelete.UseVisualStyleBackColor = true; this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click); // // btnAddNode // this.btnAddNode.Location = new System.Drawing.Point(5, 30); this.btnAddNode.Name = "btnAddNode"; this.btnAddNode.Size = new System.Drawing.Size(75, 23); this.btnAddNode.TabIndex = 20; this.btnAddNode.Text = "添加根"; this.btnAddNode.UseVisualStyleBackColor = true; this.btnAddNode.Click += new System.EventHandler(this.btnAddNode_Click); // // btnAddChild // this.btnAddChild.Location = new System.Drawing.Point(99, 30); this.btnAddChild.Name = "btnAddChild"; this.btnAddChild.Size = new System.Drawing.Size(75, 23); this.btnAddChild.TabIndex = 21; this.btnAddChild.Text = "添加子级"; this.btnAddChild.UseVisualStyleBackColor = true; this.btnAddChild.Click += new System.EventHandler(this.btnAddChild_Click); // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(224, 9); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(65, 12); this.label2.TabIndex = 7; this.label2.Text = "节点信息:"; // // dataGridView1 // this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGridView1.BackgroundColor = System.Drawing.SystemColors.Window; dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control; dataGridViewCellStyle1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText; dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1; this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window; dataGridViewCellStyle2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText; dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False; this.dataGridView1.DefaultCellStyle = dataGridViewCellStyle2; this.dataGridView1.Location = new System.Drawing.Point(226, 24); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.ReadOnly = true; dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control; dataGridViewCellStyle3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText; dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.dataGridView1.RowHeadersDefaultCellStyle = dataGridViewCellStyle3; this.dataGridView1.RowTemplate.Height = 23; this.dataGridView1.Size = new System.Drawing.Size(346, 326); this.dataGridView1.TabIndex = 1; this.dataGridView1.SelectionChanged += new System.EventHandler(this.dataGridView1_SelectionChanged); // // btnQuery // this.btnQuery.Location = new System.Drawing.Point(226, 370); this.btnQuery.Name = "btnQuery"; this.btnQuery.Size = new System.Drawing.Size(75, 44); this.btnQuery.TabIndex = 2; this.btnQuery.Text = "查询(&S)"; this.btnQuery.UseVisualStyleBackColor = true; this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click); // // btnExit // this.btnExit.Location = new System.Drawing.Point(226, 429); this.btnExit.Name = "btnExit"; this.btnExit.Size = new System.Drawing.Size(75, 44); this.btnExit.TabIndex = 3; this.btnExit.Text = "退出(&C)"; this.btnExit.UseVisualStyleBackColor = true; this.btnExit.Click += new System.EventHandler(this.btnExit_Click); // // btnEdit // this.btnEdit.Enabled = false; this.btnEdit.Location = new System.Drawing.Point(19, 370); this.btnEdit.Name = "btnEdit"; this.btnEdit.Size = new System.Drawing.Size(75, 23); this.btnEdit.TabIndex = 15; this.btnEdit.Text = "编辑"; this.btnEdit.UseVisualStyleBackColor = true; this.btnEdit.Click += new System.EventHandler(this.btnEdit_Click); // // tbNodeName // this.tbNodeName.Location = new System.Drawing.Point(74, 3); this.tbNodeName.Name = "tbNodeName"; this.tbNodeName.Size = new System.Drawing.Size(100, 21); this.tbNodeName.TabIndex = 19; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(3, 6); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(65, 12); this.label3.TabIndex = 18; this.label3.Text = "节点名称:"; // // btnModify // this.btnModify.Location = new System.Drawing.Point(409, 464); this.btnModify.Name = "btnModify"; this.btnModify.Size = new System.Drawing.Size(75, 23); this.btnModify.TabIndex = 13; this.btnModify.Text = "修改(&M)"; this.btnModify.UseVisualStyleBackColor = true; this.btnModify.Click += new System.EventHandler(this.btnModify_Click); // // btnRemove // this.btnRemove.Location = new System.Drawing.Point(490, 464); this.btnRemove.Name = "btnRemove"; this.btnRemove.Size = new System.Drawing.Size(75, 23); this.btnRemove.TabIndex = 14; this.btnRemove.Text = "删除(&D)"; this.btnRemove.UseVisualStyleBackColor = true; this.btnRemove.Click += new System.EventHandler(this.btnRemove_Click); // // btnAdd // this.btnAdd.Location = new System.Drawing.Point(328, 464); this.btnAdd.Name = "btnAdd"; this.btnAdd.Size = new System.Drawing.Size(75, 23); this.btnAdd.TabIndex = 12; this.btnAdd.Text = "新增(&A)"; this.btnAdd.UseVisualStyleBackColor = true; this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click); // // tbID // this.tbID.Location = new System.Drawing.Point(465, 356); this.tbID.Name = "tbID"; this.tbID.ReadOnly = true; this.tbID.Size = new System.Drawing.Size(100, 21); this.tbID.TabIndex = 5; // // tbName // this.tbName.Location = new System.Drawing.Point(465, 410); this.tbName.Name = "tbName"; this.tbName.Size = new System.Drawing.Size(100, 21); this.tbName.TabIndex = 9; // // tbCategory // this.tbCategory.Location = new System.Drawing.Point(465, 437); this.tbCategory.Name = "tbCategory"; this.tbCategory.Size = new System.Drawing.Size(100, 21); this.tbCategory.TabIndex = 11; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(382, 359); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(77, 12); this.label4.TabIndex = 4; this.label4.Text = "ID(产品ID):"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(358, 413); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(101, 12); this.label5.TabIndex = 8; this.label5.Text = "Name(物品名称):"; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(334, 440); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(125, 12); this.label6.TabIndex = 10; this.label6.Text = "Category(物品类别):"; // // tbParentID // this.tbParentID.Location = new System.Drawing.Point(465, 383); this.tbParentID.Name = "tbParentID"; this.tbParentID.Size = new System.Drawing.Size(100, 21); this.tbParentID.TabIndex = 7; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(346, 386); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(113, 12); this.label7.TabIndex = 6; this.label7.Text = "ParentID(父节点):"; // // panel1 // this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.btnAddNode); this.panel1.Controls.Add(this.btnAddChild); this.panel1.Controls.Add(this.tbNodeName); this.panel1.Enabled = false; this.panel1.Location = new System.Drawing.Point(14, 410); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(177, 56); this.panel1.TabIndex = 17; // // Form1 // this.AcceptButton = this.btnQuery; this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(577, 496); this.Controls.Add(this.panel1); this.Controls.Add(this.label6); this.Controls.Add(this.label5); this.Controls.Add(this.label7); this.Controls.Add(this.label4); this.Controls.Add(this.tbCategory); this.Controls.Add(this.tbName); this.Controls.Add(this.tbParentID); this.Controls.Add(this.tbID); this.Controls.Add(this.btnAdd); this.Controls.Add(this.btnRemove); this.Controls.Add(this.btnModify); this.Controls.Add(this.btnEdit); this.Controls.Add(this.btnExit); this.Controls.Add(this.btnQuery); this.Controls.Add(this.dataGridView1); this.Controls.Add(this.label2); this.Controls.Add(this.btnDelete); this.Controls.Add(this.label1); this.Controls.Add(this.treeView1); this.Name = "Form1"; this.Text = "TreeViewText by danch744"; this.Load += new System.EventHandler(this.Form1_Load); this.contextMenuStrip1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.TreeView treeView1; private System.Windows.Forms.Label label1; private System.Windows.Forms.Button btnDelete; private System.Windows.Forms.Button btnAddNode; private System.Windows.Forms.Button btnAddChild; private System.Windows.Forms.Label label2; private System.Windows.Forms.DataGridView dataGridView1; private System.Windows.Forms.Button btnQuery; private System.Windows.Forms.Button btnExit; private System.Windows.Forms.Button btnEdit; private System.Windows.Forms.TextBox tbNodeName; private System.Windows.Forms.Label label3; private System.Windows.Forms.Button btnModify; private System.Windows.Forms.Button btnRemove; private System.Windows.Forms.Button btnAdd; private System.Windows.Forms.TextBox tbID; private System.Windows.Forms.TextBox tbName; private System.Windows.Forms.TextBox tbCategory; private System.Windows.Forms.Label label4; private System.Windows.Forms.Label label5; private System.Windows.Forms.Label label6; private System.Windows.Forms.TextBox tbParentID; private System.Windows.Forms.Label label7; private System.Windows.Forms.Panel panel1; private System.Windows.Forms.ContextMenuStrip contextMenuStrip1; private System.Windows.Forms.ToolStripMenuItem 展开树ToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem 节点ToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem 节点及其所有子节点ToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem 删除ToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem 展开所有节点ToolStripMenuItem; } }
点上面的那个图标显示代码。另外说一下,数据库的定义就在那张图片那样定义,主键是ID,ID和ParentID都是int,其余两个都是nvarchar,数据库名:TreeView,表为TreeNode,具体可以从代码看出来。
要源代码及数据库的朋友请留下邮箱,第一次在博客园发帖,还请各位高手指点迷津,虚心接受批评。。。