.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