DataTable dtA = GetTable("select * form A");// 取出A表的数据
foreach (DataRow dr in dtA.Rows)
{
TreeNode tnParent = new TreeNode();
tnParent.Name = dr["aid"].ToString();
tnParent.Text = dr["aName"].ToString();
DataTable dtB = GetTable("select * from B where bid in(select bid from AB where aid = '" + dr["aid"].ToString() + "')");//取出A下的节点
foreach (DataRow dr in dtB.Rows)
{
TreeNode tnChild = new TreeNode();
tnChild.Text = dr["bName"].ToString();
tnChild.Name = dr["bid"].ToString();
DataTable dtA = GetTable("select * form A");// 取出A表的数据
foreach (DataRow dr in dtA.Rows)
{
TreeNode tnParent = new TreeNode();
tnParent.Name = dr["aid"].ToString();
tnParent.Text = dr["aName"].ToString();
DataTable dtB = GetTable("select * from B where bid in(select bid from AB where aid = '" + dr["aid"].ToString() + "')");//取出A下的节点
foreach (DataRow dr in dtB.Rows)
{
TreeNode tnChild = new TreeNode();
tnChild.Text = dr["bName"].ToString();
tnChild.Name = dr["bid"].ToString();