Hello,

Please forgive me for lack of understanding about the reported problem.

Intersoft have WebGrid sample that maybe similar with your current scenario, WebGrid client binding with pagination.

If you don’t mind, please kindly have review in the ClientBinding_Paging.aspx WebGrid samples and let us know your response.

(start > All Programs > Intersoft WebUI Studio 2012 R2 > WebUI Studio for ASP.NET > WebGrid 8 > C# Samples.

The physical location of the file is: "%ProgramFiles%\Intersoft Solutions\Intersoft WebUI Studio 2012 R2\Samples\For ASP.NET\ISNet.WebUI.Samples\cs\WebGrid\ClientBinding_Paging.aspx".)

Regards,

Hans.

Hi,

I have this almost working now.

Page Source Source:

<ISWebGrid:WebGrid ID="WebGrid2" runat="server" Height="250px" 
    UseDefaultStyle="True" Width="500px" DataSourceID="ISDataSource1">
    <LayoutSettings PagingLoadMode="Custom" PagingMode="ClassicPaging" 
        PagingStyleUI="Slider" PagingDataRetrievalMode="ReturnPartialRows" 
        PagingSize="20">
    </LayoutSettings>
    <RootTable>
        <Columns>
            <ISWebGrid:WebGridColumn Name="CustomerId" Caption="Customer Id" DataMember="CustomerId" />
            <ISWebGrid:WebGridColumn Name="DisplayName" Caption="Display Name" DataMember="DisplayName" Width="200"/>
        </Columns>
    </RootTable>
</ISWebGrid:WebGrid>
<ISDataSource:ISDataSource ID="ISDataSource1" runat="server" 
    SchemaType="CustomObject" LoadOnDemand="true">
    <Tables>
        <ISDataSource:ISDataSourceTable SelectMethod="GetData" SelectCountMethod="SelectCount" TableName="Customers" EnablePaging="true"
            TypeName="WebGridPaging.CustomersISDataAdapter" >
        </ISDataSource:ISDataSourceTable>
    </Tables>
</ISDataSource:ISDataSource>

ISData Adapter Code:

    public class CustomersISDataAdapter
    {
        public CustomersISDataAdapter()
        {
        }
        private Customers _lastCustomers = null;
        public CustomersISDataCollection GetData(string sortExpression, int maximumRows, int startRowIndex)
        {
            Customers items = Customers.GetCustomers(startRowIndex, maximumRows);
            this._lastCustomers = items;
            CustomersISDataCollection dataCollection = CustomersISDataCollection.CreateISDataCollection(items);
            return dataCollection;
        }
        public int SelectCount(string sortExpression)
        {
            return this._lastCustomers.MaxRowIndex;
        }
    }

For some reason the GetData method is always called twice.

It's called twice when the page loads and twice everytime I page.

No grid events are being handled in the code behind.

I have two questions:



1) How can I stop the GetData call being made twice.

2) Why does the return object of GetData need to inherit IHierarchicalList. I can do theGrid.DataSource = theCustomers, where theCustomers is of type CUstomers, and it works fine...but returning a Customers object gives an error when using the ISDataSource saying the collection must implement IHierarchicalList. This means I have to take my customer objects and add them to a special collection before I return them.

cheers,

Steve

Hello,

1) The GetPagedBugs (if you see ClientBiding_Paging.aspx sample) is being called twice indeed.

This happen due to the sample is using pagination feature. First, it will select all data then it will select again for the paging.

2) If you are using Intersoft sample, it should use IHierarchicalList indeed, because data source collection of the sample is using hierarchical collection.

If you don’t the hierarchical collection, you should your own data source collection.

Thank you.

Regards,

Hans.