分页我用的是PagingToolbar
连接的sql
代码:
<ext:Store ID="Store1" runat="server" OnRefreshData="Store1_RefershData" AutoLoad="true">
<Reader>
<ext:JsonReader>
<Fields>
<ext:RecordField Name="LogID" />
<ext:RecordField Name="Module" />
<ext:RecordField Name="Operate" />
<ext:RecordField Name="Content" />
<ext:RecordField Name="UserName" />
<ext:RecordField Name="UserRole" />
<ext:RecordField Name="CreateTime" Type="Date" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
后台
protected void Store1_RefershData(object sender, StoreRefreshDataEventArgs e)
{
int PageSize = this.pagecut.PageSize; //获取当前在页面中PagingToolBar 的PageSize的值
int Count = 0;
int CurPage = e.Start / PageSize + 1; //获取当前的页码是多少,也就是第几页
string strWhere = "1=1";
var store = this.GPLog.GetStore();
// store.DataSource = list;
// store.DataBind();
DataTable dt = m_QueryPagination("P_log", "LogID,Module,Operate,Content,UserName,UserRole,CreateTime", strWhere, PageSize, CurPage, out Count); //连接数据库
e.Total = Count;
this.pagecut.DisplayMsg = CurPage + " - " + PageSize + "条 共 " + e.Total + " 条";
if (Count > 0)
{
store.DataSource = dt;//绑定数据