private void LoadData() { StringBuilder sb = new StringBuilder(); if (!string.IsNullOrEmpty(txtstartime.Text) && !string.IsNullOrEmpty(txtenddate.Text)) { sb.AppendFormat("and cast (WriteTime as date) between '{0}' and '{1}'", Convert.ToDateTime(txtstartime.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtenddate.Text).ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(txtUserName.Text)) { sb.AppendFormat(" and UserID like '%{0}%'", txtUserName.Text.Trim()); } string sql = string.Format("select *,UserID+'|'+ cast (cast(WriteTime as date) as varchar(10)) as ID from t_failrequestInfo where 1=1 {0} ", sb.ToString()); DataSet ds2 = userbll.GetSqlList(sql); DataSet ds = userbll.ExecuteSqlPager(sql, "UserID", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize); Gdv_data.DataSource = ds.Tables[0]; Gdv_data.DataBind(); int RecordCount = ds2.Tables[0].Rows.Count; AspNetPager1.PageSize = RecordCount; AspNetPager1.RecordCount = RecordCount; }
private void LoadData() { string strWhere = string.Empty; if (!string.IsNullOrEmpty(txtUserName.Text)) { strWhere = string.Format(" UserName like '%{0}%'", txtUserName.Text.Trim()); } string sql = string.Format("select * from t_userinfo {0} ", strWhere != ""?"where " + strWhere:""); DataSet ds2 = userbll.GetList(strWhere); DataSet ds = userbll.ExecuteSqlPager(sql, "ID", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize); Gdv_data.DataSource = ds.Tables[0]; Gdv_data.DataBind(); int RecordCount = ds2.Tables[0].Rows.Count; AspNetPager1.RecordCount = RecordCount; }