Repeater控件、DataList控件套用

.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>&nbsp;&nbsp;</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