62,039
社区成员
发帖
与我相关
我的任务
分享
DataSet data = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//data = 数据;
SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select * from parent_channel ", conn);
conn.Open();
da.Fill(data);
InitTree(TreeView1.Nodes, "0");
}
}
public void InitTree(TreeNodeCollection Nds, string parentID)
{
TreeNode newNode;
DataRow[] rows = data.Tables[0].Select("parentid=" + parentID);
foreach (DataRow row in rows)
{
newNode = new TreeNode(
row["title"].ToString(),
row["lid"].ToString(),
row["lid"].ToString());
Nds.Add(newNode);
InitTree(newNode.ChildNodes, row["lid"].ToString());
}
}
数据表结构