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(); }
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(); } }
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(); } }