public SqlConnection con = new SqlConnection(); protected void Page_Load(object sender, EventArgs e) { Load_tree(); } protected DataSet PDataset(string select_statement) { Connect(); con.Open(); SqlDataAdapter ad = new SqlDataAdapter(select_statement, con); DataSet ds = new DataSet(); ad.Fill(ds); con.Close(); return ds; } public void Connect() { con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["cnstring"].ConnectionString); } public void Load_tree() { DataSet PrSet = PDataset("SELECT * FROM Location where ID>1"); TreeView1.Nodes.Clear(); foreach (DataRow dr in PrSet.Tables[0].Rows) { if ((int)dr["ParentID"] == 1) { TreeNode tnParent = new TreeNode(); tnParent.Text = dr["Title"].ToString(); string value = dr["ID"].ToString(); tnParent.Expand(); TreeView1.Nodes.Add(tnParent); FillChild(tnParent, value); } } } public int FillChild(TreeNode parent, string IID) { DataSet ds = PDataset("SELECT * FROM Location WHERE ParentID =" + IID); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { TreeNode child = new TreeNode(); child.Text = dr["Title"].ToString().Trim(); string temp = dr["ID"].ToString(); child.Collapse(); parent.ChildNodes.Add(child); FillChild(child, temp); } return 0; } else { return 0; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)