Repeater 控件 + 分頁控件的使用

昵稱10504424 2013-07-15

展開全文

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<asp:Repeater ID="rptList" runat="server">

                             <ItemTemplate>

                                 <div class="saleexpo_div" onmouseover="this.style.backgroundColor='#FFFFEF'" onmouseout="this.style.backgroundColor=''">

                                     <div class="saleexpo_div1">

                                         <a href="ConventionDetailsApply.aspx?ConList=<%#Eval("ExhibitionID")%>" target="_blank">

                                             <img id="Img1" alt="" src='<%# myUtilitiesCS.ChkImageExist(0,"images/Exhibition/"+ DataBinder.Eval(Container.DataItem,"ImageUrl"),"images/NoPhoto_Exh.jpg")%>'

                                                 runat="server">

                                         </a>

                                     </div>

                                     <div class="saleexpo_div2">

                                         <h2>

                                             <a href='ConventionDetailsApply.aspx?ConList=<%#Eval("ExhibitionID")%>' target="_blank">

                                                 <asp:Label ID="Label1" runat="server" Text='<%#Eval("TitleValue") %>'></asp:Label>

                                             </a>

                                         </h2>

<p>

                                             <span>展會(huì)時(shí)間：</span><%# DateTime.Parse(Eval("StartDT").ToString()).ToShortDateString()+"  至  "+DateTime.Parse(Eval("EndDT").ToString()).ToShortDateString() %>

                                         </p>

<p>

                                             <span>展會(huì)地址：</span><%#Eval("CountryName").ToString()+Eval("AreaName").ToString()%>

                                         </p>

<p>

                                             <span>展會(huì)簡介：</span>

                                             <%#Eval("ContentValue") %>

                                         </p>

                                     </div>

                                 </div>

                                 <div class="saleexpo_divl">

                                 </div>

                             </ItemTemplate>

                         </asp:Repeater>

=============================

后臺(tái)代碼 A.aspx.cs:

public partial class ConventionList : System.Web.UI.Page

    protected void Page_Load(object sender, EventArgs e)

        if (!IsPostBack)

            BindToDataList();

    protected void AspNetPager1_PageChanged(object sender, EventArgs e)

        BindToDataList();

    private void BindToDataList()

        int pageIndex = this.AspNetPager1.CurrentPageIndex - 1;

        int pageSize = 5;

        this.AspNetPager1.PageSize = pageSize;

        int firstPage = pageIndex * pageSize;

        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

        string sql = "select M.ExhibitionID,M.SystemID,M.TitleValue,M.ContentValue,M.ScopeValue,M.OrganizerValue,Country.CountryName,Area.AreaName,E.ExhibitionID,E.HttpUrl,E.StartDT,E.EndDT,E.ImageUrl from Country left join Area on Country.CountryID=Area.CountryID left join Pavilion on Area.AreaID=Pavilion.AreaID left join Exhibition E on E.PavilionID=Pavilion.PavilionID left join MultiLangExpo M on M.ExhibitionID=E.ExhibitionID where M.SystemID=1 and E.TypeID=1 and E.deleted=0 and StartDT > getDate() order by StartDT Desc";

        SqlDataAdapter da = new SqlDataAdapter(sql,conn);

        DataSet ds = new DataSet();

        da.Fill(ds, firstPage, pageSize, "listall");

        DataTable dt = ds.Tables["listall"];

        AspNetPager1.RecordCount = getCount();

        rptList.DataSource = dt;

        rptList.DataBind();

    private int getCount()

        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

        string sql = "";

        sql = "select Count(E.ExhibitionID) from Country left join Area on Country.CountryID=Area.CountryID left join Pavilion on Area.AreaID=Pavilion.AreaID left join Exhibition E on E.PavilionID=Pavilion.PavilionID left join MultiLangExpo M on M.ExhibitionID=E.ExhibitionID where M.SystemID=1 and E.TypeID=1 and E.deleted=0 and StartDT > getDate()";

        SqlCommand com = new SqlCommand(sql, con);

        con.Open();

        int temp = Convert.ToInt32(com.ExecuteScalar());

        con.Close();

        return temp;

本站是提供個(gè)人知識(shí)管理的網(wǎng)絡(luò)存儲(chǔ)空間，所有內(nèi)容均由用戶發(fā)布，不代表本站觀點(diǎn)。請(qǐng)注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購買等信息，謹(jǐn)防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊一鍵舉報(bào)。

轉(zhuǎn)藏 分享

QQ空間 QQ好友新浪微博微信

獻(xiàn)花（0） +1

來自：昵稱10504424 > 《工作》

舉報(bào)/認(rèn)領(lǐng)