电竞比分网-中国电竞赛事及体育赛事平台

搜索
分享

Repeater 控件 + 分頁控件的使用

 昵稱10504424 2013-07-15

前臺頁面 A.aspx:

 

 

 

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

后臺代碼 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;
    }
}

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

    0條評論

    發(fā)表

    請遵守用戶 評論公約

    類似文章 更多