Radgrid custom paging with hierarchy

[Mehmet Tirgil]

Hi,
I try to use custom paging in radgrid with hierarcy. If i use just paging everthing works fine. But if i use custum paging, the main table works fine with virtualitemcount property, but can not paging in sub tables.

This is my grid properties.
 <telerik:RadGrid ID="GvwItems" runat="server" ClientIDMode="AutoID" AutoGenerateColumns="False" GridLines="None" EnableLinqExpressions="False" Skin="Office2007" AllowPaging="True" AllowCustomPaging="true" PageSize="25" AllowSorting="True">
 
This is NeedDataSource Event
If IsExpanded = True OrElse e.IsFromDetailTable = True Then
GvwItems.VirtualItemCount = MyTable.Rows(0).Item("RCount")
Else
GvwItems.MasterTableView.VirtualItemCount = MyTable.Rows(0).Item("RCount")
End If

[Tsvetoslav]

Hello Mehmet,

Thank you for contacting us.

Attached is a small sample that demonstrates how to use custom paging in a hierarchical grid and how to correctly set the VirtualItemCount property.

Do let us know how it goes.

Best wishes,
Tsvetoslav
the Telerik team

[Mehmet Tirgil]

Hi,
Thanks for reply. But i do not use detailtable. I use SelfHierarchySetting. My grid properties like below.

 <telerik:RadGrid ID="GvwItems" runat="server" ClientIDMode="AutoID" AutoGenerateColumns="False" GridLines="None" EnableLinqExpressions="False" Skin="Office2007" AllowPaging="True" AllowCustomPaging="true" PageSize="25" AllowSorting="True">
                <ClientSettings>
                    <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" />
                    <ClientEvents OnRowDblClick="RowDblClick" />
                </ClientSettings>
                <MasterTableView DataKeyNames="PageId,ContentId,ContentLevel,ParentContentLevel,HasChild" AllowFilteringByColumn="True" AllowCustomPaging="true" HierarchyLoadMode="ServerOnDemand">
                    <ExpandCollapseColumn></ExpandCollapseColumn>
                    <SelfHierarchySettings ParentKeyName="ParentContentLevel" KeyName="ContentLevel"></SelfHierarchySettings>
                    <Columns>
                        <telerik:GridBoundColumn DataField="ListOrder" HeaderText="ListOrder"
                            UniqueName="ListOrder" AllowFiltering="false"
                            DataType="System.Int32">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ContentHeader" HeaderText="ContentHeader"
                            UniqueName="ContentHeader" AutoPostBackOnFilter="True"
                            ShowFilterIcon="False">
                        </telerik:GridBoundColumn>                        
                    </Columns>                   
                </MasterTableView>               
            </telerik:RadGrid>       

[Mehmet Tirgil]

Hi, I understood that, i can use detailtables with selfhierarchysettings. I used it. Now it look likes below, and custom paging is work now. But there are two problems. One is DetailTableDatabind fire two times, i do not understand why. I change my code in detailtabledatabind like that

If FirstTime = True then
bla bla...
.datasource = ...
FirstTime = false
End If

And the second problem is; NeeddataSource event fire when detailtabledatabind fires, so grid is recreated and add below of detailtable. So i make change my code in needdatadource like that

If IsExpanded = False andalso e.IsFromDetailTable = False Then
bla bla...
grid.datasource = ...
End If

This is my new grid codes
<telerik:RadGrid ID="GvwItems" runat="server" ClientIDMode="AutoID" AutoGenerateColumns="False" GridLines="None" EnableLinqExpressions="False" Skin="Office2007" AllowPaging="True" AllowCustomPaging="true" PageSize="25" AllowSorting="True">
                <ClientSettings>
                    <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" />
                    <ClientEvents OnRowDblClick="RowDblClick" />
                </ClientSettings>
                <MasterTableView DataKeyNames="PageId,ContentId,ContentLevel,ParentContentLevel,HasChild" AllowFilteringByColumn="True" AllowCustomPaging="true" HierarchyLoadMode="ServerOnDemand">
                    <ExpandCollapseColumn></ExpandCollapseColumn>
                    <SelfHierarchySettings ParentKeyName="ParentContentLevel" KeyName="ContentLevel"></SelfHierarchySettings>
                    <Columns>
                        <telerik:GridBoundColumn DataField="ListOrder" HeaderText="ListOrder"
                            UniqueName="ListOrder" AllowFiltering="false"
                            DataType="System.Int32">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ContentHeader" HeaderText="ContentHeader"
                            UniqueName="ContentHeader" AutoPostBackOnFilter="True"
                            ShowFilterIcon="False">
                        </telerik:GridBoundColumn>                       
                    </Columns>
                    <DetailTables>
                        <telerik:GridTableView AllowPaging="true" AllowCustomPaging="true">
                            <Columns>
                                <telerik:GridBoundColumn DataField="ListOrder" HeaderText="ListOrder"
                                    UniqueName="ListOrder" AllowFiltering="false"
                                    DataType="System.Int32">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ContentHeader" HeaderText="ContentHeader"
                                    UniqueName="ContentHeader" AutoPostBackOnFilter="True"
                                    ShowFilterIcon="False">
                                </telerik:GridBoundColumn>                               
                            </Columns>
                        </telerik:GridTableView>
                    </DetailTables>                
                </MasterTableView>               
            </telerik:RadGrid> 

I found another problem. If I change pagesize,  e.IsfromDetailTable is false when needdatasource event fires and detailtabledatabind does not fire. ???

[Tsvetoslav]

Hi Mehmet,

Please, open up a formal support ticket and send your files - your mark-up snippets do not provide enough information to determine the cause of the problem.

Regards, Tsvetoslav
the Telerik team