C#创建树形结构

最新推荐文章于 2024-08-09 18:00:00 发布

番茄贱

最新推荐文章于 2024-08-09 18:00:00 发布

阅读量3.9k

点赞数

分类专栏： C# WinForm 树

本文链接：https://blog.csdn.net/hanchangning19890201/article/details/76021171

版权

C# WinForm 树专栏收录该内容

1 篇文章 0 订阅

订阅专栏

string connString = "User ID=sys;Password=sys;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";
OracleConnection conn = new OracleConnection(connString);
try
{
//连接数据库
conn.Open();
//查询数据库
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select no,name from sys.t_org where type=1 ";
OracleDataReader dr=cmd.ExecuteReader();
if (dr.HasRows)
{
while(dr.Read()){
string no = dr["no"].ToString();
string name = dr["name"].ToString();
TreeNode node = new TreeNode();
node.Name = no;
node.Text = name;
directoryTree.Nodes.Add(node);
cTree(node,node.Name);
}
}

// MessageBox.Show(conn.State.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();

}

递归方法：

string connString = "User ID=sys;Password=sys;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";
OracleConnection conn = new OracleConnection(connString);
try
{
//连接数据库
conn.Open();
//查询数据库
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select no,name from sys.t_org where p_no='"+node.Name+"'";
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string no = dr["no"].ToString();
string name = dr["name"].ToString();
TreeNode nodes = new TreeNode();
nodes.Name = no;
nodes.Text = name;

node.Nodes.Add(nodes);
cTree(nodes,nodes.Name);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}