public override void DataBind() { string sqlWhere = " 1=1 "; //string searchText = ttbSearchMessage.Text.Trim(); if (!String.IsNullOrEmpty(txtdates.Text)) { sqlWhere += string.Format(" And sendTime>'{0}' ", Convert.ToDateTime(txtdates.Text)); } if (!String.IsNullOrEmpty(txtDateE.Text)) { sqlWhere += string.Format(" And sendTime<'{0}' ", Convert.ToDateTime(txtDateE.Text).AddDays(1)); } if (drptype.SelectedValue != "0") { sqlWhere += string.Format(" And type='{0}'", drptype.SelectedValue); } int s = Pager.PageSize * (Pager.CurrentPageIndex - 1); int e = Pager.PageSize * Pager.CurrentPageIndex; DataTable dt = bll.GetListByPage(sqlWhere, " id ", s, e).Tables[0]; Pager.RecordCount = bll.GetRecordCount(sqlWhere); CompanyRepeater.DataSource = dt; CompanyRepeater.DataBind(); base.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ScriptManager.RegisterClientScriptInclude(Page, Page.GetType(), "popUpListHandler", ResolveClientUrl("~/javascript/popUpListHandler.js")); ScriptManager.RegisterClientScriptInclude(Page, Page.GetType(), "advancedCheckBoxListHandler", ResolveClientUrl("~/javascript/advancedCheckBoxListHandler.js")); if (!IsPostBack) { ArrayList list = ECompany.db.select(dbConn, new DBFilter()); CompanyRepeater.DataSource = list; CompanyRepeater.DataBind(); } }