话不多说，上图先。
前台代码：
<table cellpadding="0" cellspacing="1" width="100%"> <asp:Repeater ID="rptClass" runat="server" onitemdatabound="rptClass_ItemDataBound"> <ItemTemplate> <tr style=" height:30px;" mce_style=" height:30px;"> <td colspan="5" style=" color:#000; font-size:14px; font-weight:bold;" mce_style=" color:#000; font-size:14px; font-weight:bold;"> <%#Eval("JobName") %> </td> </tr> <asp:Repeater ID="rptsClass" runat="server" onitemdatabound="rptsClass_ItemDataBound"> <ItemTemplate> <tr style=" background-color:#d9e9ff; height:24px; padding-top:2px;"> <td style=" font-weight:bold; color:#000;" mce_style=" font-weight:bold; color:#000;"> <%#Eval("FuncName")%> </td> <asp:Repeater ID="rptShowJob" runat="server"> <ItemTemplate> <td onmousemove=" this.style.backgroundColor='#d5b760'; this.style.color='#fff'" onmouseout="this.style.backgroundColor='';this.style.color='';"> <%# Eval("FuncSubName")%> </td> </ItemTemplate> </asp:Repeater> </tr> </ItemTemplate> </asp:Repeater> </ItemTemplate> </asp:Repeater> </table>
后台代码：
//第一级绑定 private void bindRpt() { string sql = ""; sql = "SELECT * FROM jobtemplates"; rptClass.DataSource = sssDB.GetDataTable(sql); rptClass.DataBind(); } //绑定层级 protected void rptClass_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { string preid = ((DataRowView)e.Item.DataItem).Row["id"].ToString(); //获得对应ID Repeater bsClass = (Repeater)e.Item.FindControl("rptsClass"); //找到要绑定数据的Repeater if (bsClass != null) { string sqlstr = "SELECT DISTINCT(FuncName),FuncCate FROM admfunc WHERE FID=" + preid + " "; bsClass.DataSource = sssDB.GetDataTable(sqlstr); bsClass.DataBind(); } } } //绑定职们信息 protected void rptsClass_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { string cid = ((DataRowView)e.Item.DataItem).Row["FuncCate"].ToString(); //获得对应ID Repeater rptShowJob = (Repeater)e.Item.FindControl("rptShowJob"); //找到要绑定数据的Repeater if (rptShowJob != null) { string sqlstr = "SELECT FuncSubName FROM admfunc WHERE FuncCate='" + cid + "' ORDER BY FuncCate"; rptShowJob.DataSource = sssDB.GetDataTable(sqlstr); rptShowJob.DataBind(); } } }
数据库关系图
数据库数据
