//数据库连接
...........
//查询语句
OleDbCommand cmd = new OleDbCommand("select unique parentName from SCate order by ID DESC", con);
OleDbDataReader read = cmd.ExecuteReader();
while(read.Read())
{
//第一层循环读取parentName
TreeNode tnRoot = new TreeNode();
tnRoot.Text = read.Getstring(0);
OleDbCommand cmd1 = new OleDbCommand("select NodeName from SCate where parentName ="'+tnRoot.Text+'" order by ID DESC", con);
OleDbDataReader read1 = cmd1.ExecuteReader();
//第2层循环 根据parentName 读取相应的NodeName
while(read1.Read())
{
TreeNode tnChild = new TreeNode();
tnChild.Text = read1.GetString(0);
tnRoot.ChildNodes.Add(tnChild);
}
//添加到控件中
TreeView1.Nodes.Add(tnRoot);
}
OleDbConnection con = new OleDbConnection(XClass.DB.dbstr);
OleDbCommand cmd = new OleDbCommand("select * from BCate order by ID DESC", con);
con.Open();
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
TreeNode tempnode = new TreeNode();
tempnode.Name = "P" + read[0].ToString();
tempnode.Text = read[1].ToString();
Tree_CateList.Nodes.Add(tempnode);
}
read.Close();
cmd = new OleDbCommand("select * from SCate order by ID DESC", con);
read = cmd.ExecuteReader();
while (read.Read())
{
TreeNode tempnode1 = new TreeNode();
tempnode1.Name = read[0].ToString();
tempnode1.Text = read[1].ToString();