protected void Page_Load(object sender, EventArgs e)
    {
        var BookList     = BookUtil.CreateBookList();
        var CategoryList = BookList.Select(p => new { p.Category, p.CategoryImageUrl, p.CategoryUrl }).Distinct();

        RptCategory.DataSource = CategoryList;
        RptCategory.DataBind();

        RptBooks.DataSource = BookList;
        RptBooks.DataBind();
    }
Example #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         string    UserName = Convert.ToString(Session["UserName"]);
         string    sql      = "select * from Message where UserName = '******' and MessageId = '0'";
         DataTable dt       = new DataTable();
         SQL.sqldt(sql, dt);
         RptCategory.DataSource = dt;
         RptCategory.DataBind();
     }
 }
Example #3
0
    void DataBindToRepeater(int currentPage)
    {
        string    sql = "select * from librarybooks";
        DataTable dt  = new DataTable();

        SQL.sqldt(sql, dt);
        PagedDataSource pds = new PagedDataSource();

        pds.AllowPaging        = true;
        pds.PageSize           = 1;
        pds.DataSource         = dt.DefaultView;
        lbTotal.Text           = pds.PageCount.ToString();
        pds.CurrentPageIndex   = currentPage - 1;//当前页数从零开始,故把接受的数减一
        RptCategory.DataSource = pds;
        RptCategory.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        var BookList = BookUtil.CreateBookList();

        string queryString = Request.QueryString["category"];

        if ((queryString != String.Empty) && (queryString != null))
        {
            LitTitle.Text             = "Books";
            PnlSectionItemRow.Visible = true;
            string categoryUrl = "category/" + queryString;
            RptBooks.DataSource = BookList.Where(p => p.CategoryUrl == categoryUrl);
            RptBooks.DataBind();
        }
        else
        {
            LitTitle.Text       = "Categories";
            RptCategory.Visible = true;
            var CategoryList = BookList.Select(p => new { p.Category, p.CategoryImageUrl, p.CategoryUrl }).Distinct();
            RptCategory.DataSource = CategoryList;
            RptCategory.DataBind();
        }
    }