循环递归treeview节点树

数据库T2表

 

 

//1读取数据库文件根据ParentId 返回一个list集合

private List<T2> GetData(int i)

{

  List<T2> list = new List<T2>();

  string sql = "select Id,Name from T2 where ParentId="+i;

  using(SqlDataReader reader = SqlHelper.ExecuteReader(sql))

  {

    if(read.HasRows)

    {

       while(reader.Read())

       {

         T2 t = new T2();

         t.Id = Convert.ToInt32(reader["Id"]);

         t.Name = reader["Name"].toString();

         list.Add(t);

       }

    }

  }

}

 

//根据list集合插入数据到节点树

private void SetTreeViewNodesByList(List<T2>,TreeNodeCollection tnc)

{

  for(int i =0;i<list.Count;i++)

  {

    TreeNode tn =  tnc.Add(list[i].Name);

    SetTreeViewNodesByList(GetData(list[i].Id),tn.Nodes);

  }

}

 

//加载窗体出发时间

private void Load(object sender, EventArgs e)

{

  List<T2> list = GetData(0);

  SetTreeViewNodesByList(list,treeView1.Nodes);

}