.aspx代码：
<table> <asp:Repeater ID="RepeaterShanWu" runat="server" OnItemDataBound="RepeaterShanWu_ItemDataBound"> <ItemTemplate> <tr> <td> <h3 class="mainbnei-h3"> <%# getMajorName(Convert.ToInt32(Eval("course_Major")))%></h3> </td> </tr> <tr> <td> <table width="600px" border="0" cellspacing="1" cellpadding="1" bgcolor="#000000" style="text-align: center; background-color: #000000"> <tr style=""> <asp:DataList ID="DataListShanWu" runat="server" RepeatColumns="6"> <ItemTemplate> <td width="100px" height="28px"> <a href='courseLook.aspx?course_ID=<%# Eval("course_ID") %>' style="color: Blue; text-decoration: underline"> <%# Eval("course_Name") %> </a> </td> </ItemTemplate> </asp:DataList></tr> </table> </td> </tr> </ItemTemplate> </asp:Repeater> </table>
.aspx.cs代码：
/// <summary> /// 获取专业的ID /// </summary> /// <param name="major_ID">专业名称</param> /// <returns></returns> public string getMajorName(int major_ID) { string sql = "select major_Name from major where major_ID="+major_ID; string majorName = DbHelperOleDb.GetSingle(sql).ToString(); return majorName; } /// <summary> ///绑定专业分类 /// </summary> private void BindData() { string sql = "select course_Major from course group by course_Major"; DataSet ds = DbHelperOleDb.Query(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { this.RepeaterShanWu.DataSource = ds; this.RepeaterShanWu.DataBind(); ds.Dispose(); } }
protected void RepeaterShanWu_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList DL_URL = (DataList)e.Item.FindControl("DataListShanWu");//找到页面中的datalist DataRowView drv = (DataRowView)e.Item.DataItem; string TypeID = drv["course_Major"].ToString();//提取大类中的值 DataSet ds = new dalCourse().GetList(" course_Major="+Convert.ToInt32(TypeID)); DL_URL.DataSource = ds;//从数据据库取值 绑定 DL_URL.DataBind(); }
}
效果如图：
2011-04-26 22:46:25
