二、实现部分代码
List<TreeNode> parent = new List<TreeNode>();
DBHelper db = new DBHelper();
private void DisplayTreeView()
{
string sql = "select * from t_menu where parentid = 0";
MySqlDataReader reader = db.GetDataReader(sql);
while (reader.Read())
{
TreeNode tree = new TreeNode();
tree.Text = reader["menuname"].ToString();
tree.Name = reader["id"].ToString();
parent.Add(tree);
menuTree.Nodes.Add(tree);
}
reader.Close();
LevelSearch(parent);
}
private void LevelSearch(List<TreeNode> parent)
{
foreach (TreeNode node in parent)
{
string sql = "select * from t_menu where parentid = " + node.Name;
MySqlDataReader reader = db.GetDataReader(sql);
List<TreeNode> T = new List<TreeNode>();
while (reader.Read())
{
TreeNode tree = new TreeNode();
tree.Text = reader["menuname"].ToString();
tree.Name = reader["id"].ToString();
node.Nodes.Add(tree);
T.Add(tree);
}
reader.Close();
LevelSearch(T);
}
}