更新时间2018-12-27 09:49:24
string sql = "select distinct comName,lasttime,sh,ds,qx,jd from (select distinct comName,(select SUM(case when comName is not null then 1 else 0 end) from yhzc where comName = a.comName) as num,(select MAX(checkPositionTime) from yhzc where comName=a.comName) as lasttime,sh,ds,qx,jd,datatype from yhzc a join Company b on a.CompanyID=b.Company) as c where num > 0";
DataTable dt = CommonApp.getCompanyInfo(selectSql(sql).ToString()).Tables[0];
DataGrid2.DataSource = dt;
if (DataGrid2.CurrentPageIndex > (dt.Rows.Count - 1) / DataGrid2.PageSize)
DataGrid2.CurrentPageIndex = (dt.Rows.Count - 1) / DataGrid2.PageSize;
DataGrid2.DataBind();
dt.Dispose();
加载数据慢,是一次性加载数据量太大了,分页不要用组件来分页,应在数据库取数据的时候直接分页好,在sql语句或存储过程中分页。分页的技术无非是先排序,然后想办法取到你计算出来的从第几行到第几行的数据,当然是有一点点小小的技巧的。