[CLOSED] LinqDataSource and remote paging

[John_Writers]

Hi to everybody,
LinqDataSource with GripdPanel load all records present in a table. I wish to load only a record that are present in my page and not load all and after paging.

Is it possibile with gridpanel and LinqDataSource?

I configure it with the follows settings
LinqDataSource:

<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="TeleCARE.Web.Data.MSDDatabase"
                    Select="new (ID_Device)" TableName="Devices" AutoPage="true" EnableDelete="true" EnableInsert="true"
                    EnableUpdate="true" />

GridPanel:

<ext:GridPanel ID="gpDevices" runat="server" Width="1000" Height="400" AutoWidth="true"
                    AutoHeight="true">
                    <ColumnModel ID="ColumnModel1" runat="server">
                        <Columns>
                            <ext:Column ColumnID="ID_Device" Header="ID_Device" Width="160" Align="Left"
                                DataIndex="ID_Device">
                            </ext:Column>
                           
                        </Columns>
                    </ColumnModel>
                    <Store>
                        <ext:Store ID="stDevices" runat="server" DataSourceID="LinqDataSource1" AutoLoad="true"
                            RemotePaging="true" RemoteSort="true">                         
                            <Reader>
                                <ext:JsonReader>
                                    <Fields>
                                        <ext:RecordField Name="ID_Device" Type="Int" />                                        
                                    </Fields>
                                </ext:JsonReader>
                            </Reader>
                             <AutoLoadParams>
                                <ext:Parameter Name="start" Value="0" Mode="Raw" />
                                <ext:Parameter Name="limit" Value="20" Mode="Raw" />
                            </AutoLoadParams>
                            <BaseParams>
                                <ext:Parameter Name="startRemote" Value="#{stDevices}.pageIndex" Mode="Raw" />
                                <ext:Parameter Name="limitRemote" Value="20" Mode="Raw" />
                            </BaseParams>
                        </ext:Store>
                    </Store>
                    <SelectionModel>
                        <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
                    </SelectionModel>
                   
                    <BottomBar>
                        <ext:PagingToolbar runat="server" StoreID="stDevices" ID="ptDevices">
                        </ext:PagingToolbar>
                    </BottomBar>
                    <View>
                        <ext:GridView AutoFill="true" ForceFit="true" />
                    </View>
                </ext:GridPanel>

Thanks for support.

Bye

[Daniil]

Hi,

Please follow
https://examples1.ext.net/#/GridPane..._Sorting/Page/

[John_Writers]

thanks, I solved my problem.