RAD Grid Hierarchy modify for child is not working

[Pradeep]

Hello ,

  I am facing a proble  when i am try to modify my child row in RAD Grid. following the my code base of gridl

<

 

 

telerik:RadGrid ID="rgSortCodes" runat="server"

 

 

 

OnItemDataBound="rgSortCodes_ItemDataBound"

 

 

 

OnUpdateCommand="rgSortCodes_UpdateCommand" OnDeleteCommand="rgSortCodes_DeleteCommand"

 

 

 

OnEditCommand="rgSortCodes_EditCommand" OnPageIndexChanged="rgSortCodes_PageIndexChanged"

 

 

 

OnPageSizeChanged="rgSortCodes_PageSizeChanged" OnCancelCommand="rgSortCodes_CancelCommand"

 

 

 

AllowPaging="True" PageSize="10" OnItemCreated="rgSortCodes_ItemCreated" ShowFooter="True"

 

 

 

GridLines="None" meta:resourcekey="rgSortCodesResource1" OnDetailTableDataBind="rgSortCodes_DetailTableBind" >

 

 

 

<ValidationSettings ValidationGroup="SortCodeGrid" />

 

 

 

<HeaderStyle HorizontalAlign="Center" />

 

 

 

<MasterTableView DataKeyNames="ID" AutoGenerateColumns="False" AllowAutomaticUpdates="true" AllowAutomaticDeletes="True" EditMode="InPlace" >

 

 

 

 

<DetailTables>

 

 

 

<telerik:GridTableView Width="50%" runat="server" EditMode="InPlace" AutoGenerateColumns="false" Name="Serial" ShowHeader="true" >

 

 

 

 

<ParentTableRelation>

 

 

 

<telerik:GridRelationFields MasterKeyField="ID" DetailKeyField="iSortID" />

 

 

 

</ParentTableRelation>

 

 

 

<Columns>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="iSortID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn Visible="true" DataField="ID"></telerik:GridBoundColumn>

 

 

 

 

<telerik:GridTemplateColumn HeaderText="iSortID" UniqueName="iSortID">

 

 

 

<ItemTemplate>

 

 

 

<telerik:RadTextBox ID="txtSerialNumber" runat="server" MaxLength="30" Enabled="false" Text='<%# Bind("Serialnumber") %>'>

 

 

 

</telerik:RadTextBox>

 

 

 

</ItemTemplate>

 

 

 

<EditItemTemplate>

 

 

 

<telerik:RadTextBox ID="txtSerialNumberEdit" runat="server" MaxLength="30" Text='<%# Bind("Serialnumber") %>'>

 

 

 

</telerik:RadTextBox>

 

 

 

</EditItemTemplate>

 

 

 

</telerik:GridTemplateColumn>

 

 

 

 

<telerik:GridEditCommandColumn EditText="Modify"

 

 

 

UniqueName="EditColumn" ButtonType="PushButton">

 

 

 

<ItemStyle Wrap="False"></ItemStyle>

 

 

 

</telerik:GridEditCommandColumn>

 

 

 

 

<telerik:GridButtonColumn CommandName="Delete"

 

 

 

meta:resourcekey="GridButtonColumnResource1" Text="Delete" UniqueName="DeleteColumn" ButtonType="ImageButton" >

 

 

 

<ItemStyle Wrap="False"></ItemStyle>

 

 

 

</telerik:GridButtonColumn>

 

 

 

</Columns>

 

 

 

</telerik:GridTableView>

 

 

 

</DetailTables>

 

 

 

<EditItemTemplate>

 

<

 

 

asp:Literal ID="litNoSortCodes" runat="server" Text="No data to display"

 

 

 

meta:resourcekey="litNoSortCodesResource1"></asp:Literal>

 

 

</

 

 

EditItemTemplate>

 

<

 

 

commanditemsettings exporttopdftext="Export to Pdf"></commanditemsettings>

 

<

 

 

Columns>

 

<

 

 

telerik:GridBoundColumn Aggregate="Count" DataField="OrderLineNumber" HeaderText="Line #"

 

 

 

meta:resourcekey="GridBoundColumnResource1" ReadOnly="True"

 

 

 

UniqueName="OrderLineNumber"></telerik:GridBoundColumn>

 

<

 

 

telerik:GridBoundColumn DataField="Action" HeaderText="Action"

 

 

 

meta:resourcekey="GridBoundColumnResource2" ReadOnly="True" UniqueName="Action"></telerik:GridBoundColumn>

 

<

 

 

telerik:GridBoundColumn DataField="MatItem" HeaderText="Sort Code"

 

 

 

meta:resourcekey="GridBoundColumnResource3" ReadOnly="True"

 

 

 

UniqueName="MatItem"></telerik:GridBoundColumn>

 

 

<

 

 

telerik:GridTemplateColumn>

 

<

 

 

HeaderTemplate>Serial# rqd?</HeaderTemplate>

 

<

 

 

ItemTemplate>

 

<

 

 

asp:DropDownList ID="drpSerialRQD" runat="server" Enabled="false">

 

<

 

 

asp:ListItem>Y</asp:ListItem>

 

<

 

 

asp:ListItem Selected="True">N</asp:ListItem>

 

<

 

 

asp:ListItem>ER</asp:ListItem>

 

</

 

 

asp:DropDownList>

 

</

 

 

ItemTemplate>

 

</

 

 

telerik:GridTemplateColumn>

 

<

 

 

telerik:GridTemplateColumn>

 

<

 

 

HeaderTemplate>Serial Number</HeaderTemplate>

 

<

 

 

ItemTemplate>

 

<

 

 

asp:TextBox ID="txtGridSerialNumber" runat="server" Enabled="false"></asp:TextBox>

 

</

 

 

ItemTemplate>

 

</

 

 

telerik:GridTemplateColumn>

 

<

 

 

telerik:GridBoundColumn DataField="DescriptionE" HeaderText="Description"

 

 

 

meta:resourcekey="GridBoundColumnResource4" ReadOnly="True"

 

 

 

UniqueName="Description"></telerik:GridBoundColumn>

 

 

<

 

 

telerik:GridNumericColumn DataField="CurrentQuantity" HeaderText="Current Quantity"

 

 

 

meta:resourcekey="GridNumericColumnResource1" ReadOnly="True"

 

 

 

UniqueName="CurrentQuantity"></telerik:GridNumericColumn>

 

<

 

 

telerik:GridNumericColumn DataField="RevisedQuantity"

 

 

 

HeaderText="Revised Quantity" meta:resourcekey="GridNumericColumnResource2"

 

 

 

UniqueName="RevisedQuantity"></telerik:GridNumericColumn>

 

<

 

 

telerik:GridNumericColumn DataField="UnitPrice" HeaderText="Unit Price"

 

 

 

meta:resourcekey="GridNumericColumnResource3" NumericType="Currency"

 

 

 

UniqueName="UnitPrice"></telerik:GridNumericColumn>

 

<

 

 

telerik:GridBoundColumn DataField="SAPLineNumber" HeaderText="SAP Line Number"

 

 

 

meta:resourcekey="GridBoundColumnResource12" ReadOnly="True"

 

 

 

UniqueName="SAPLineNumber"></telerik:GridBoundColumn>

 

<

 

 

telerik:GridEditCommandColumn EditText="Modify"

 

 

 

meta:resourcekey="GridEditCommandColumnResource1" UniqueName="EditColumn" ButtonType="PushButton">

 

 

 

<ItemStyle Wrap="False"></ItemStyle>

 

</

 

 

telerik:GridEditCommandColumn>

 

<

 

 

telerik:GridButtonColumn CommandName="Delete"

 

 

 

meta:resourcekey="GridButtonColumnResource1" Text="Cancel" UniqueName="DeleteColumn" ButtonType="PushButton">

 

 

 

<ItemStyle Wrap="False"></ItemStyle>

 

</

 

 

telerik:GridButtonColumn>

 

</

 

 

Columns>

 

</

 

 

MasterTableView>

 

</

 

 

telerik:RadGrid>

 

when i am try to click on the child's Modify button i am getting

Line: 938
Error: Sys.WebForms.PageRequestManagerServerErrorException: Cannot find column [iSortID]


I did all left right to find the solution.

Please help on this

Regards
Pradeep

[Iana Tsolova]

Hi Pradeep,

Can you specify how it the MasterTableView bound? I see that the detail tables are bound through the DetailTableDataBind event. In this case you should bind the grid through the NeedDataSource as in this topic.
I also observed that you do not set the DataKeyNames for the detail GridTableView. I assume there you should add the iSortID.
Additionally, when the hierarchical grid is bound through the above event, you would better have no ParenttableRelations as there are to be used where you are using declarative DataSource controls for binding the grid.
Another thing I saw in the provided code, is that you have not set the UniqueName for the columns. Try setting it and see if it makes any difference.
Furthermore, if the grid is ajaxified, try disabling ajax and run the page in Debug mode. After you make sure everything is working and no server-side errors are thrown, you can enable ajax back.

All the best,
Iana
the Telerik team