Databases
StackOverflow2013
Postsdbo
POExt.net How to set total page for pagingtoolbar?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExt.net How to set total page for pagingtoolbar?
    text
    copied!<p>i have a dataset, in dataset i have two function : <code>GetDataMenuPagin(@PageIndex, @PageSize)</code> <code>SP_GetCountMenuDataPagin()</code> I get data from a table named "Menu" with 1500 record. I set page size is 10, so total page must be 150 page. But how i can set total for pagingtoolbar ?</p> <p>This is my object data source &amp; store , i using dataset:</p> <pre><code>&lt;asp:ObjectDataSource ID="MenuDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetDataMenuPagin" EnablePaging="false" TypeName="dsHorizonTableAdapters.MenuTableAdapter" OnUpdating="MenuDataSourceUpdating" DataObjectTypeName="System.Guid" DeleteMethod="Delete" InsertMethod="Insert" OnSelecting="MenuDataSource_Selecting"&gt; &lt;InsertParameters&gt; &lt;asp:Parameter DbType="Guid" Name="Id" /&gt; &lt;asp:Parameter DbType="Guid" Name="ParentMenuId" /&gt; &lt;asp:Parameter DbType="Guid" Name="PageId" /&gt; &lt;asp:Parameter Name="Criteria" Type="String" /&gt; &lt;asp:Parameter Name="Display" Type="String" /&gt; &lt;asp:Parameter Name="Description" Type="String" /&gt; &lt;asp:Parameter Name="MenuURL" Type="String" /&gt; &lt;asp:Parameter Name="Sort" Type="String" /&gt; &lt;asp:Parameter Name="IsActive" Type="Boolean" /&gt; &lt;asp:Parameter Name="UpdateDate" Type="DateTime" /&gt; &lt;asp:Parameter Name="UpdateUser" Type="String" /&gt; &lt;asp:Parameter DbType="Guid" Name="MethodId" /&gt; &lt;asp:Parameter Name="Image" Type="String" /&gt; &lt;asp:Parameter DbType="Guid" Name="ProgramId" /&gt; &lt;asp:Parameter DbType="Guid" Name="StatusId" /&gt; &lt;/InsertParameters&gt; &lt;SelectParameters&gt; &lt;asp:Parameter DefaultValue="0" Name="PageIndex" Type="Int32" /&gt; &lt;asp:Parameter DefaultValue="10" Name="PageSize" Type="Int32" /&gt; &lt;/SelectParameters&gt; &lt;/asp:ObjectDataSource&gt; &lt;ext:Store ID="MenuStore" runat="server" DataSourceID="MenuDataSource" AutoDataBind="false" AutoLoad="false" onrefreshdata="MenuStore_RefreshData"&gt; &lt;Reader&gt; &lt;ext:JsonReader IDProperty="Id" AutoDataBind="True"&gt; &lt;Fields&gt; &lt;ext:RecordField Name="Id" /&gt; &lt;ext:RecordField Name="ParentMenuId" /&gt; &lt;ext:RecordField Name="PageId" /&gt; &lt;ext:RecordField Name="Criteria" /&gt; &lt;ext:RecordField Name="Display" /&gt; &lt;ext:RecordField Name="Description" /&gt; &lt;ext:RecordField Name="MenuURL" /&gt; &lt;ext:RecordField Name="IsActive" DefaultValue="true" /&gt; &lt;ext:RecordField Name="Sort" DefaultValue="0" /&gt; &lt;ext:RecordField Name="UpdateDate" Type="Date" /&gt; &lt;ext:RecordField Name="UpdateUser" /&gt; &lt;ext:RecordField Name="ParentMenuDisplay" /&gt; &lt;ext:RecordField Name="PageDisplay" /&gt; &lt;/Fields&gt; &lt;/ext:JsonReader&gt; &lt;/Reader&gt; &lt;Listeners&gt; &lt;LoadException Handler="Ext.Msg.Alert('Column - Load failed', e.message || e )" /&gt; &lt;CommitFailed Handler="Ext.Msg.Alert('Column - Commit failed', 'Reason: ' + msg)" /&gt; &lt;SaveException Handler="Ext.Msg.Alert('Column - Save failed', e.message || e)" /&gt; &lt;CommitDone Handler="Ext.Msg.Alert('Column - Commit', 'The data successfully saved');" /&gt; &lt;/Listeners&gt; &lt;/ext:Store&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload