This is a migrated thread and some comments may be shown as answers.

[Solved] Detail table paging not working

3 Answers 191 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Narendra
Top achievements
Rank 1
Narendra asked on 06 Jan 2009, 02:42 PM
I have a grid with a single Detail Table into it. 
Basically, master table is category which just displays category name and detail table displays records for that related parent category. 
Detail table has 5 columns. Evenrything is fine but paging in detail table is not working. 
Even though each category has more than 2 records with PageSize=2; it doesn't display more than 1 page in paging control.
What seems to be wrong here? Appreciate any help!!
~Narendra

ASPX:
<telerik:RadGrid ID="RadGridParent" runat="server" EnableAJAX="True" GridLines="None"  
            ShowGroupPanel="True" Skin="Office2007" AutoGenerateColumns="False" Description="Messages"  
            ShowStatusBar="True" Subtitle="Messages" Title="Messages" Width="98%"  
            OnItemCommand="RadGridParent_ItemCommand" ShowHeader="False" 
            PagerStyle-AlwaysVisible="False" AllowPaging="True" PageSize="2"  
            OnDetailTableDataBind="RadGridParent_DetailTableDataBind"  
            onitemdatabound="RadGridParent_ItemDataBound"  
            onneeddatasource="RadGridParent_NeedDataSource" 
            onprerender="RadGridParent_PreRender" AllowSorting="True"  
            AllowMultiRowSelection="True"
        <MasterTableView DataKeyNames="CategoryID" CommandItemDisplay="Top"
            <DetailTables> 
                <telerik:GridTableView runat="server" DataKeyNames="CategoryID"  
                        AutoGenerateColumns="False" GridLines="Both"  
                        CommandItemDisplay="Bottom" AllowAutomaticInserts="false" AllowAutomaticUpdates="false"  
                        HierarchyLoadMode="ServerOnDemand" ShowHeader="True"  
                    PagerStyle-AlwaysVisible="True" AllowCustomPaging="True" 
                    BorderStyle="Ridge" Width="100%" 
                        NoDetailRecordsText="There are no messages." > 
                    <ParentTableRelation> 
                        <telerik:GridRelationFields DetailKeyField="CategoryID" MasterKeyField="CategoryID"  /> 
                    </ParentTableRelation> 
                    <RowIndicatorColumn Visible="false"
                        <HeaderStyle Width="20px" /> 
                    </RowIndicatorColumn> 
                    <ExpandCollapseColumn Resizable="False"
                        <HeaderStyle Width="20px" />                             
                    </ExpandCollapseColumn> 
                    <PagerStyle Mode="NumericPages"></PagerStyle> 
                     <CommandItemTemplate> 
                        <div> 
                          <table border=0 cellspacing=0 cellpadding=0 width="100%"
                            <tr> 
                                <td width="40%"
                                    <div style="float:left;"
                                    <asp:LinkButton ID="btnDeleteMessage" ConfirmText="Sure?" runat="server" Text="Delete Selected" CommandName="MessageDelete" OnClientClick="return ConfirmDelete(this);" SkinId="swGridDeleteSelectedLinkButton"</asp:LinkButton> 
                                    </div> 
                                </td> 
                                <td width="20%"
                                    <div style="float:left;"
                                        <asp:LinkButton ID="btnMessageMarkAsRead" runat="server" Text="Mark Selected as Read" CommandName="MessageMarkRead" SkinId="swGridMarkMessageReadLinkButton"</asp:LinkButton> 
                                    </div> 
                                </td> 
                                <td width="40%"
                                    <div style="float:right;"
                                        <asp:LinkButton ID="btnMessageMarkAsUnread" runat="server" Text="Mark Selected as Unread" CommandName="MessageMarkUnread" SkinId="swGridMarkMessageUnreadLinkButton"></asp:LinkButton> 
                                    </div> 
                                </td> 
                            </tr> 
                          </table> 
                        </div> 
                    </CommandItemTemplate>         
                    <Columns> 
                     
                    <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn"  HeaderText="Select All"
                    <HeaderStyle Width="10px" /> 
                    </telerik:GridClientSelectColumn> 
                        <telerik:GridBoundColumn DataField="IsRead" DataType="System.String" HeaderText=""  Groupable="false"  
                                SortExpression="IsRead" UniqueName="MessageReadIcon" Visible="True"
                                <HeaderStyle Width="10px" /> 
                                <ItemStyle Width="10px" /> 
                        </telerik:GridBoundColumn> 
 
                        <telerik:GridBoundColumn DataField="CategoryID" DataType="System.Int32"  Groupable="false"  
                                ReadOnly="True" SortExpression="NotificationMsgID" UniqueName="NotificationMsgID" Visible="False">                     
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="NotificationMsgUserID" DataType="System.Int32"  Groupable="false"  
                                ReadOnly="True" SortExpression="NotificationMsgUserID" UniqueName="NotificationMsgUserID" Visible="False">    
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="RVNotificationMsgUser" DataType="System.Int32"  Groupable="false"  
                                ReadOnly="True" UniqueName="RVNotificationMsgUser" Visible="False">    
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="Topic" HeaderText="Topic" DataType="System.String" Groupable="false"  
                                SortExpression="Topic" UniqueName="Topic">                     
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="SendDate" DataType="System.DateTime"  Groupable="false"  
                                HeaderText="Date" SortExpression="SendDate" UniqueName="SendDate">                     
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="Sender" DataType="System.String" HeaderText="From"  Groupable="false"  
                                SortExpression="Sender" UniqueName="Sender"
                            <ItemStyle Width="140px" /> 
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="MessageText" DataType="System.String" HeaderText="Message" Groupable="false" SortExpression="MessageText"  
                                UniqueName="MessageText">                     
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="SenderUserLastName" UniqueName="SenderUserLastName" Groupable="false" Visible="False">  
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="SenderUserFirstName" UniqueName="SenderUserFirstName" Groupable="false" Visible="False">  
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="SenderUserMiddleName" UniqueName="SenderUserMiddleName" Groupable="false" Visible="False">  
                        </telerik:GridBoundColumn> 
                    </Columns>      
                    <editformsettings> 
                        <popupsettings scrollbars="None" /> 
                    </editformsettings> 
                </telerik:GridTableView> 
            </DetailTables> 
             
            <editformsettings> 
                <popupsettings scrollbars="None" /> 
            </editformsettings> 
             
            <CommandItemTemplate> 
                <div style="float:right;text-align:right"
                    <asp:LinkButton ID="LinkButton4" runat="server" CommandName="RebindGrid" 
                            SkinID="swGridRefreshLinkButton" Text="Refresh" ToolTip="Refresh"</asp:LinkButton> 
                </div> 
            </CommandItemTemplate> 
            <RowIndicatorColumn Visible="False"
                <HeaderStyle Width="20px"></HeaderStyle> 
            </RowIndicatorColumn>  
            <ExpandCollapseColumn Visible="true" Resizable="False"
                <HeaderStyle Width="20px"></HeaderStyle> 
            </ExpandCollapseColumn> 
            <Columns> 
                <telerik:GridBoundColumn DataField="MessageDescription" HeaderText="Messages"  
                    SortExpression="MessageDescription" UniqueName="MessageDescription"  
                    ItemStyle-Font-Bold="true" Groupable="false">                     
                    <ItemStyle Font-Bold="True" /> 
                </telerik:GridBoundColumn> 
                <telerik:GridBoundColumn DataField="CategoryID" UniqueName="CategoryID" HeaderText="" Visible="False"
                </telerik:GridBoundColumn> 
            </Columns> 
        </MasterTableView> 
        <GroupPanel ID="SystemWorksStandardGridGroupPanel" Text="Notifications"
          <PanelStyle Width="100%" Height="20px" /> 
        </GroupPanel> 
        <ClientSettings AllowColumnsReorder="False" AllowDragToGroup="True" ReorderColumnsOnClient="False"
            <Selecting AllowRowSelect="True" /> 
            <Scrolling AllowScroll="false" UseStaticHeaders="false" /> 
        </ClientSettings> 
        <PagerStyle Mode="NumericPages"></PagerStyle> 
</telerik:RadGrid> 
 

CS
protected void RadGridMessages_NeedDataSource(object source, GridNeedDataSourceEventArgs e) 
        { 
            if (!e.IsFromDetailTable) 
            { 
                LoadParentData(); 
            } 
        } 
 
 
        private void LoadParentData() 
        { 
            Category[] cats = new Category[2]; 
 
            Category cat1= new Category(); 
            cat1.MessageTypeID = 1; 
            cat1.MessageDescription = "Catorogy 1"
            cats [0] = cat1 ; 
 
            cat1.MessageTypeID = 2; 
            cat1.MessageDescription = "Category 2"
            cats[1] = cat1; 
 
            RadGridParent.MasterTableView.DataSource = cats; 
        } 
 
        protected void RadGridParent_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e) 
        { 
            childDataSource[] childDS; 
 
            GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem; 
            int catId = Int32.Parse(dataItem.GetDataKeyValue("CategoryID").ToString()); 
 
            childDS = GetChildDataSourceByCategory(catId); 
             
        e.DetailTableView.DataSource = childDS; 
        } 
 
 


3 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 06 Jan 2009, 04:16 PM
Hello Narendra,

Please set the AllowCustomPaging property (residing in the DetailTable) to false and let me know whether this helps.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Anil Sahu
Top achievements
Rank 1
answered on 10 Sep 2009, 11:37 AM
Hello All,
             I am sorry, I am new User , so i dont know from where i can send my Queries.
        Now my Query is , i want to Custom Paging in GridTableView ,There should be Numeric paging and buttons, Onclick event it should  show 10 more records NEXT,(BeckButton)as well as BECK records. and there should be another button on click of that  which shows me All records..This GridTableView is within the RadGrid control. code is here
"
<telerik:RadGrid ID="MetersRadGrid"  runat="server" Width="100%" AutoGenerateColumns="False"
                                            AllowMultiRowSelection="True" AllowPaging="True" PageSize="6" AllowSorting="true"
                                            GridLines="None" EnableViewState="true" OnItemCreated="MetersRadGrid_ItemCreated"
                                            OnDetailTableDataBind="MeterRadGrid_DetailTableDataBind" OnNeedDataSource="MetersRadGrid_NeedDataSource">
                                            <ClientSettings AllowKeyboardNavigation="True">
                                                <Selecting AllowRowSelect="true" />
                                            </ClientSettings>
                                            <HeaderContextMenu>
                                                <CollapseAnimation Duration="200" Type="OutQuint" />
                                            </HeaderContextMenu>
                                            <MasterTableView Width="100%"  CommandItemDisplay="Top" HierarchyDefaultExpanded="false" DataKeyNames="MeterID" HierarchyLoadMode="Client" Name="MeterDetailTable"
                                                DataMember="MeterDetailTable">
                                                <RowIndicatorColumn Visible="False">
                                                    <HeaderStyle Width="20px" />
                                                </RowIndicatorColumn>
                                                <CommandItemTemplate>
                                                    <table width="100%">
                                                        <tr>
                                                            <td style="width: 20%">
                                                                <asp:Image ID="AddNewContactImage" runat="server" ImageUrl="~/Images/AddRecord.gif"
                                                                    AlternateText="Add Record" />&nbsp;&nbsp;
                                                                <asp:LinkButton ID="AddNewMeterLinkButton" runat="server" Text="Add New Meter"></asp:LinkButton>
                                                                 <script type="text/javascript">
                                                                     var linkButton = document.getElementById('<%# Container.FindControl("AddNewMeterLinkButton").ClientID %>');
                                                                     linkButton.focus();                                   
                                                                 </script>
                                                            </td>
                                                            <td style="width: 80%">
                                                                <asp:LinkButton ID="MeterExpandCollapseAllLinkButton" runat="server" Font-Bold="true"
                                                                    ForeColor="Blue" Text="Expand/Collapse Section" OnClick="MeterExpandCollapseAllLinkButton_Click"></asp:LinkButton>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </CommandItemTemplate>
                                                <CommandItemStyle BackColor="#B3D4FF" Font-Bold="True" ForeColor="Black" Height="10%" />
                                                <Columns>
                                                    <telerik:GridTemplateColumn HeaderText="Action" UniqueName="TemplateColumn1">
                                                        <ItemTemplate>
                                                            <asp:LinkButton ID="EditMeterLinkButton" runat="server" Text="Edit"></asp:LinkButton>
                                                        </ItemTemplate>
                                                    </telerik:GridTemplateColumn>
                                                    <telerik:GridBoundColumn DataField="MeterType" HeaderText="Meter Type" UniqueName="MeterType">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="ActualReading" HeaderText="Actual" UniqueName="ActualReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="AcquireReading" HeaderText="Acquire" UniqueName="AcquireReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterOffset" HeaderText="Total Offset" UniqueName="MeterOffset"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="BeginFYReading" HeaderText="Begin FY" UniqueName="BeginFYReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterYearToDate" HeaderText="Year-to-Date" UniqueName="MeterYearToDate"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterFleetToDate" HeaderText="Fleet-to-Date"
                                                        UniqueName="MeterFleetToDate" DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterLifeToDate" HeaderText="Life-to-Date" UniqueName="MeterLifeToDate"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterLifeExpectancy" HeaderText="Life Expectancy"
                                                        UniqueName="MeterLifeExpectancy" DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="Status" HeaderText="Status" UniqueName="Status">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="Digit" HeaderText="Digit" UniqueName="Digit"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                </Columns>
                                                <DetailTables>
                                                    <telerik:GridTableView Width="100%" runat="server" PageSize="2" AllowCustomPaging="true"  Name="MeterReadingDetailTable"
                                                        DataKeyNames="MeterTransactionID,MeterID" DatasourcePersistenceMode="ViewState"
                                                        HierarchyLoadMode="Client" CommandItemDisplay="Top">
                                                        <ExpandCollapseColumn Visible="True">
                                                        </ExpandCollapseColumn>
                                                        <CommandItemTemplate>
                                                            <table width="100%">
                                                                <tr>
                                                                    <td align="left" style="width: 20%">
                                                                        <asp:Image ID="AddNewContactImage" runat="server" ImageUrl="~/Images/AddRecord.gif"
                                                                            AlternateText="Add Record" />&nbsp;&nbsp;
                                                                        <asp:LinkButton ID="AddNewReadingLinkButton" Text="Add New Reading" runat="server"></asp:LinkButton>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </CommandItemTemplate>
                                                        <Columns>
                                                            <telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Action">
                                                                <ItemTemplate>
                                                                    <asp:LinkButton ID="EditMeterReadingLinkButton" runat="server" Text="Edit"></asp:LinkButton>
                                                                </ItemTemplate>
                                                            </telerik:GridTemplateColumn>
                                                            <telerik:GridBoundColumn DataField="Reading" HeaderText="Reading" UniqueName="Reading"
                                                                DataFormatString="{0:N0}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" HorizontalAlign="Right" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Invalid" HeaderText="Invalid" UniqueName="Invalid">
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Override" HeaderText="Override" UniqueName="Override">
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Offset" HeaderText="Offset" DataFormatString="{0:N0}"
                                                                UniqueName="Offset">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" HorizontalAlign="Right" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="TransactionDate" HeaderText="Trans Date and Time"
                                                                UniqueName="TransactionDate" DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Source" HeaderText="Source" UniqueName="source">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="CreatedDate" HeaderText="Created" UniqueName="CreatedDate"
                                                                DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="CreatedBy" HeaderText="Created By" UniqueName="CreatedBy">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="ModifiedDate" HeaderText="Modified" UniqueName="ModifiedDate"
                                                                DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="ModifiedBy" HeaderText="Modified By" UniqueName="ModifiedBy">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                        </Columns>
                                                        <PagerStyle Mode="NextPrevAndNumeric" />
                                                    </telerik:GridTableView>
                                                </DetailTables>

                                                <ExpandCollapseColumn Visible="False">
                                                    <HeaderStyle Width="19px" />
                                                </ExpandCollapseColumn>
                                                <RowIndicatorColumn Visible="False">
                                                    <HeaderStyle Width="20px" />
                                                </RowIndicatorColumn>
                                                <AlternatingItemStyle BackColor="#EFF3FB" />
                                                <SortExpressions>
                                                    <telerik:GridSortExpression FieldName="MeterID"></telerik:GridSortExpression>
                                                </SortExpressions>
                                                <PagerStyle Mode="Advanced" />
                                            </MasterTableView>
                                            <FilterMenu>
                                                <CollapseAnimation Duration="200" Type="OutQuint" />
                                            </FilterMenu>
                                        </telerik:RadGrid>

0
Anil Sahu
Top achievements
Rank 1
answered on 10 Sep 2009, 11:38 AM
Hello All,
             I am sorry, I am new User , so i dont know from where i can send my Queries.
        Now my Query is , i want to Custom Paging in GridTableView ,There should be Numeric paging and buttons, Onclick event it should  show 10 more records NEXT,(BeckButton)as well as BECK records. and there should be another button on click of that  which shows me All records..This GridTableView is within the RadGrid control. code is here
"
<telerik:RadGrid ID="MetersRadGrid"  runat="server" Width="100%" AutoGenerateColumns="False"
                                            AllowMultiRowSelection="True" AllowPaging="True" PageSize="6" AllowSorting="true"
                                            GridLines="None" EnableViewState="true" OnItemCreated="MetersRadGrid_ItemCreated"
                                            OnDetailTableDataBind="MeterRadGrid_DetailTableDataBind" OnNeedDataSource="MetersRadGrid_NeedDataSource">
                                            <ClientSettings AllowKeyboardNavigation="True">
                                                <Selecting AllowRowSelect="true" />
                                            </ClientSettings>
                                            <HeaderContextMenu>
                                                <CollapseAnimation Duration="200" Type="OutQuint" />
                                            </HeaderContextMenu>
                                            <MasterTableView Width="100%"  CommandItemDisplay="Top" HierarchyDefaultExpanded="false" DataKeyNames="MeterID" HierarchyLoadMode="Client" Name="MeterDetailTable"
                                                DataMember="MeterDetailTable">
                                                <RowIndicatorColumn Visible="False">
                                                    <HeaderStyle Width="20px" />
                                                </RowIndicatorColumn>
                                                <CommandItemTemplate>
                                                    <table width="100%">
                                                        <tr>
                                                            <td style="width: 20%">
                                                                <asp:Image ID="AddNewContactImage" runat="server" ImageUrl="~/Images/AddRecord.gif"
                                                                    AlternateText="Add Record" />&nbsp;&nbsp;
                                                                <asp:LinkButton ID="AddNewMeterLinkButton" runat="server" Text="Add New Meter"></asp:LinkButton>
                                                                 <script type="text/javascript">
                                                                     var linkButton = document.getElementById('<%# Container.FindControl("AddNewMeterLinkButton").ClientID %>');
                                                                     linkButton.focus();                                   
                                                                 </script>
                                                            </td>
                                                            <td style="width: 80%">
                                                                <asp:LinkButton ID="MeterExpandCollapseAllLinkButton" runat="server" Font-Bold="true"
                                                                    ForeColor="Blue" Text="Expand/Collapse Section" OnClick="MeterExpandCollapseAllLinkButton_Click"></asp:LinkButton>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </CommandItemTemplate>
                                                <CommandItemStyle BackColor="#B3D4FF" Font-Bold="True" ForeColor="Black" Height="10%" />
                                                <Columns>
                                                    <telerik:GridTemplateColumn HeaderText="Action" UniqueName="TemplateColumn1">
                                                        <ItemTemplate>
                                                            <asp:LinkButton ID="EditMeterLinkButton" runat="server" Text="Edit"></asp:LinkButton>
                                                        </ItemTemplate>
                                                    </telerik:GridTemplateColumn>
                                                    <telerik:GridBoundColumn DataField="MeterType" HeaderText="Meter Type" UniqueName="MeterType">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="ActualReading" HeaderText="Actual" UniqueName="ActualReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="AcquireReading" HeaderText="Acquire" UniqueName="AcquireReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterOffset" HeaderText="Total Offset" UniqueName="MeterOffset"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="BeginFYReading" HeaderText="Begin FY" UniqueName="BeginFYReading"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterYearToDate" HeaderText="Year-to-Date" UniqueName="MeterYearToDate"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterFleetToDate" HeaderText="Fleet-to-Date"
                                                        UniqueName="MeterFleetToDate" DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterLifeToDate" HeaderText="Life-to-Date" UniqueName="MeterLifeToDate"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="MeterLifeExpectancy" HeaderText="Life Expectancy"
                                                        UniqueName="MeterLifeExpectancy" DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="Status" HeaderText="Status" UniqueName="Status">
                                                    </telerik:GridBoundColumn>
                                                    <telerik:GridBoundColumn DataField="Digit" HeaderText="Digit" UniqueName="Digit"
                                                        DataFormatString="{0:N0}">
                                                    </telerik:GridBoundColumn>
                                                </Columns>
                                                <DetailTables>
                                                    <telerik:GridTableView Width="100%" runat="server" PageSize="2" AllowCustomPaging="true"  Name="MeterReadingDetailTable"
                                                        DataKeyNames="MeterTransactionID,MeterID" DatasourcePersistenceMode="ViewState"
                                                        HierarchyLoadMode="Client" CommandItemDisplay="Top">
                                                        <ExpandCollapseColumn Visible="True">
                                                        </ExpandCollapseColumn>
                                                        <CommandItemTemplate>
                                                            <table width="100%">
                                                                <tr>
                                                                    <td align="left" style="width: 20%">
                                                                        <asp:Image ID="AddNewContactImage" runat="server" ImageUrl="~/Images/AddRecord.gif"
                                                                            AlternateText="Add Record" />&nbsp;&nbsp;
                                                                        <asp:LinkButton ID="AddNewReadingLinkButton" Text="Add New Reading" runat="server"></asp:LinkButton>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </CommandItemTemplate>
                                                        <Columns>
                                                            <telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Action">
                                                                <ItemTemplate>
                                                                    <asp:LinkButton ID="EditMeterReadingLinkButton" runat="server" Text="Edit"></asp:LinkButton>
                                                                </ItemTemplate>
                                                            </telerik:GridTemplateColumn>
                                                            <telerik:GridBoundColumn DataField="Reading" HeaderText="Reading" UniqueName="Reading"
                                                                DataFormatString="{0:N0}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" HorizontalAlign="Right" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Invalid" HeaderText="Invalid" UniqueName="Invalid">
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Override" HeaderText="Override" UniqueName="Override">
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Offset" HeaderText="Offset" DataFormatString="{0:N0}"
                                                                UniqueName="Offset">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" HorizontalAlign="Right" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="TransactionDate" HeaderText="Trans Date and Time"
                                                                UniqueName="TransactionDate" DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="Source" HeaderText="Source" UniqueName="source">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="CreatedDate" HeaderText="Created" UniqueName="CreatedDate"
                                                                DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="CreatedBy" HeaderText="Created By" UniqueName="CreatedBy">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="ModifiedDate" HeaderText="Modified" UniqueName="ModifiedDate"
                                                                DataFormatString="{0:MM/dd/yyyy hh:mm tt}">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                            <telerik:GridBoundColumn DataField="ModifiedBy" HeaderText="Modified By" UniqueName="ModifiedBy">
                                                                <HeaderStyle Wrap="true" />
                                                                <ItemStyle Wrap="true" />
                                                            </telerik:GridBoundColumn>
                                                        </Columns>
                                                        <PagerStyle Mode="NextPrevAndNumeric" />
                                                    </telerik:GridTableView>
                                                </DetailTables>

                                                <ExpandCollapseColumn Visible="False">
                                                    <HeaderStyle Width="19px" />
                                                </ExpandCollapseColumn>
                                                <RowIndicatorColumn Visible="False">
                                                    <HeaderStyle Width="20px" />
                                                </RowIndicatorColumn>
                                                <AlternatingItemStyle BackColor="#EFF3FB" />
                                                <SortExpressions>
                                                    <telerik:GridSortExpression FieldName="MeterID"></telerik:GridSortExpression>
                                                </SortExpressions>
                                                <PagerStyle Mode="Advanced" />
                                            </MasterTableView>
                                            <FilterMenu>
                                                <CollapseAnimation Duration="200" Type="OutQuint" />
                                            </FilterMenu>
                                        </telerik:RadGrid>

Tags
Grid
Asked by
Narendra
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Anil Sahu
Top achievements
Rank 1
Share this question
or