using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace AspNetTest.Common { /** <summary> /// tree_DataTable 的摘要说明。 /// </summary> public class tree_DataTable : System.Web.UI.Page { private DataTable dtPowerTree = new DataTable(); const string tablename = "tree"; private void Page_Load(object sender, System.EventArgs e) { FillTreeDataTable(); blTreeDataTable(0); dtPowerTree.Clear(); // 在此处放置用户代码以初始化页面 } private void FillTreeDataTable() { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; SqlConnection conn = new SqlConnection(ConnectionString); SqlDataAdapter da = new SqlDataAdapter("select Id,PowerName,Layer,ParentId from " + tablename, conn); da.Fill(dtPowerTree); } private void blTreeDataTable(int _ParentId) { string filter = "ParentId=" + _ParentId; string sort = "Id ASC"; DataRow[] drs = dtPowerTree.Select(filter, sort); for(int i=0; i<drs.Length; i++) { if(Convert.ToInt32(drs[i][3]) == _ParentId) { int Id = Convert.ToInt32(drs[i][0]); string PowerName = drs[i][1].ToString(); int Layer = Convert.ToInt32(drs[i][2]); for(int space=1; space<=Layer; space++) { Page.Response.Write(" "); } Page.Response.Write(PowerName + "<br>"); blTreeDataTable(Id); } } } Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /** <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion } }
无限级分类
最新推荐文章于 2024-06-29 03:14:22 发布