午夜国产狂喷潮在线观看|国产AⅤ精品一区二区久久|中文字幕AV中文字幕|国产看片高清在线

前臺(tái)只需要放一個(gè) treeview控件就行

后臺(tái)

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

bindTree();

}

private void bindTree()

{

DataTable dt = this.GetTreeData();

this.FillNode(dt, null);

}

private void FillNode(DataTable dt, TreeNode node)

{

DataView dv = new DataView(dt);

if (node == null) //根結(jié)點(diǎn)

{

dv.RowFilter = "parentid='0'"; //篩選到根結(jié)點(diǎn)的所有子節(jié)點(diǎn)

}

else //不是根結(jié)點(diǎn)

{

dv.RowFilter = "parentid='" + node.Value + "'"; //篩選對(duì)應(yīng)節(jié)點(diǎn)的所有子節(jié)點(diǎn)

}

foreach (DataRowView drv in dv) //遍歷填充節(jié)點(diǎn)的所有子節(jié)點(diǎn)，如果傳入的節(jié)點(diǎn)node為葉子節(jié)點(diǎn)，遍歷要退出，不再進(jìn)行遞歸

{

TreeNode no = new TreeNode(drv["menuname"].ToString(), drv["menuid"].ToString());

FillNode(dt, no); //填充no節(jié)點(diǎn)的子節(jié)點(diǎn)

if (node == null)

{

this.TreeView1.Nodes.Add(no);

}

else

{

node.ChildNodes.Add(no);

}

}

}

private DataTable GetTreeData()

{

string strcnn = ConfigurationManager.ConnectionStrings["treecnn"].ConnectionString;

using (SqlConnection sqlcnn = new SqlConnection(strcnn))

{

SqlCommand sqlcmm = sqlcnn.CreateCommand();

sqlcmm.CommandText = "select * from MenuTree order by parentid,menuorder";

SqlDataAdapter da = new SqlDataAdapter(sqlcmm);

DataSet ds = new DataSet();

da.Fill(ds);

return ds.Tables[0];

}

}

更多信息請(qǐng)查看IT技術(shù)專欄