正文
递归绑定将数据表中的数据按层级更新到 TreeView节点上
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
private
void
bindTreeView1()
{
string
sql =
"select * from dm_category"
;
DataTable dt = db.ExecuteDataTable(sql, CommandType.Text,
null
);
DataRow[] dr = dt.Select(
"parent_id is null"
);
for
(
int
i = 0; i < dr.Length; i++)
{
TreeNode tn =
new
TreeNode();
tn.Text = dr[i][
"category_name"
].ToString();
tn.Tag = dr[i][
"id"
].ToString();
FillTree(tn, dt);
treeView1.Nodes.Add(tn);
}
}
private
void
FillTree(TreeNode node, DataTable dt)
{
DataRow[] drr = dt.Select(
"parent_id='"
+ node.Tag.ToString() +
"'"
);
if
(drr.Length > 0)
{
for
(
int
i = 0; i < drr.Length; i++)
{
TreeNode tnn =
new
TreeNode();
tnn.Text = drr[i][
"category_name"
].ToString();
tnn.Tag = drr[i][
"id"
].ToString();
if
(drr[i][
"parent_id"
].ToString() == node.Tag.ToString())
{
FillTree(tnn, dt);
}
node.Nodes.Add(tnn);
}
}
}
