have a radgrid with a nested radgrid containing child records. Everything works ok for purposes of data retrieval. Nested radgrid has in-place editing for data. When I click the edit button, the child grid disappears, leaving just the master grid in edit mode. Example shown in pic1 attached. When I click the pencil on any of the child records, that whole section disappears and the "update/cancel" buttons move up immediately under the wac pricing.
Code attached. Would like to know what I'm doing wrong, or, what I need to adjust to make it work. Thanks.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Products.aspx.cs" Inherits="CIPAS.Web.Admin.Products" MasterPageFile="../Startup/CIPAS.Master" %>
<
asp:Content
runat
=
"server"
ContentPlaceHolderID
=
"body"
>
<
telerik:RadAjaxManagerProxy
ID
=
"RadAjaxManagerProxy1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadGrid_Products"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid_Products"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid_WAC"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid_AMP"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid_BAS"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid_CMS"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManagerProxy
>
<
asp:SqlDataSource
ID
=
"SqlDataSource_Form"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'FM' OR ComboBox = '' ORDER BY Code ASC" />
<
asp:SqlDataSource
ID
=
"SqlDataSource_UOM"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'UM' OR ComboBox = '' ORDER BY Code ASC" />
<
asp:SqlDataSource
ID
=
"SqlDataSource_Products"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>"
InsertCommand="INSERT INTO ProductAdministration_Products (RowGUID_Key, NDC, NDC2, Name, Form_GUID, UOM_GUID, UnitsPerPackage, ApprovalDate, IntroductionDate, TerminationDate, ProductCode, Finance_ProductCode, UpdatedOn, UpdatedBy, sysRevision) VALUES (NEWID(), @NDC, @NDC2, @Name, @Form_GUID, @UOM_GUID, @UnitsPerPackage, @ApprovalDate, @IntroductionDate, @TerminationDate, @ProductCode, @Finance_ProductCode, GETDATE(), dbo.udf_GetEmployeeGUID(SUSER_NAME()), 0)"
SelectCommand="SELECT * FROM ProductAdministration_Products"
UpdateCommand="UPDATE ProductAdministration_Products SET NDC = @NDC, NDC2 = @NDC2, Name = @Name, Form_GUID = @Form_GUID, UOM_GUID = @UOM_GUID, UnitsPerPackage = @UnitsPerPackage, ApprovalDate = @ApprovalDate, IntroductionDate = @IntroductionDate, TerminationDate = @TerminationDate, ProductCode = @ProductCode, Finance_ProductCode = @Finance_ProductCode, UpdatedOn = GETDATE(), UpdatedBy = dbo.udf_GetEmployeeGUID(SUSER_NAME()), sysRevision = sysRevision + 1 WHERE RowGUID_Key = @RowGUID_Key" >
<
InsertParameters
>
<
asp:Parameter
Name
=
"NDC"
/>
<
asp:Parameter
Name
=
"NDC2"
/>
<
asp:Parameter
Name
=
"Name"
/>
<
asp:Parameter
Name
=
"Form_GUID"
/>
<
asp:Parameter
Name
=
"UOM_GUID"
/>
<
asp:Parameter
Name
=
"UnitsPerPackage"
/>
<
asp:Parameter
Name
=
"ApprovalDate"
/>
<
asp:Parameter
Name
=
"IntroductionDate"
/>
<
asp:Parameter
Name
=
"TerminationDate"
/>
<
asp:Parameter
Name
=
"ProductCode"
/>
<
asp:Parameter
Name
=
"Finance_ProductCode"
/>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"NDC"
/>
<
asp:Parameter
Name
=
"NDC2"
/>
<
asp:Parameter
Name
=
"Name"
/>
<
asp:Parameter
Name
=
"Form_GUID"
/>
<
asp:Parameter
Name
=
"UOM_GUID"
/>
<
asp:Parameter
Name
=
"UnitsPerPackage"
/>
<
asp:Parameter
Name
=
"ApprovalDate"
/>
<
asp:Parameter
Name
=
"IntroductionDate"
/>
<
asp:Parameter
Name
=
"TerminationDate"
/>
<
asp:Parameter
Name
=
"ProductCode"
/>
<
asp:Parameter
Name
=
"Finance_ProductCode"
/>
<
asp:Parameter
Name
=
"RowGUID_Key"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource_WAC"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" >
<
DeleteParameters
>
<
asp:Parameter
Name
=
"RowGUID_Key"
/>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"EffectiveDate"
/>
<
asp:Parameter
Name
=
"StartDate"
/>
<
asp:Parameter
Name
=
"EndDate"
/>
<
asp:Parameter
Name
=
"Price"
/>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"EffectiveDate"
/>
<
asp:Parameter
Name
=
"StartDate"
/>
<
asp:Parameter
Name
=
"EndDate"
/>
<
asp:Parameter
Name
=
"Price"
/>
<
asp:Parameter
Name
=
"RowGUID_Key"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource_AMP"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" />
<
asp:SqlDataSource
ID
=
"SqlDataSource_BAS"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" />
<
asp:SqlDataSource
ID
=
"SqlDataSource_CMS"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CIPAS.Web.Properties.Settings.CIPASCS %>" />
<
telerik:RadGrid
ID
=
"RadGrid_Products"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
GridLines
=
"None"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
DataSourceID
=
"SqlDataSource_Products"
OnItemCommand
=
"RadGrid_Products_ItemCommand"
OnItemDataBound
=
"RadGrid_Products_ItemDataBound"
>
<
MasterTableView
DataKeyNames
=
"RowGUID_Key"
EditMode
=
"PopUp"
commanditemdisplay
=
"Bottom"
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn_Products"
/>
<
telerik:GridBoundColumn
DataField
=
"Name"
FilterControlAltText
=
"Filter Name column"
HeaderText
=
"Name"
SortExpression
=
"Name"
UniqueName
=
"Name"
ItemStyle-Width
=
"70%"
/>
<
telerik:GridBoundColumn
DataField
=
"NDC"
FilterControlAltText
=
"Filter NDC column"
HeaderText
=
"NDC"
SortExpression
=
"NDC"
UniqueName
=
"NDC"
ItemStyle-Width
=
"10%"
/>
<
telerik:GridBoundColumn
DataField
=
"NDC2"
FilterControlAltText
=
"Filter NDC2 column"
HeaderText
=
"NDC2"
SortExpression
=
"NDC2"
UniqueName
=
"NDC2"
ItemStyle-Width
=
"10%"
/>
</
Columns
>
<
EditFormSettings
EditColumn-UniqueName
=
"EditCommandColumn_Products"
EditFormType
=
"Template"
CaptionDataField
=
"Name"
PopUpSettings-ScrollBars
=
"Auto"
PopUpSettings-Modal
=
"True"
PopUpSettings-Height
=
"768px"
PopUpSettings-Width
=
"1024px"
PopUpSettings-ShowCaptionInEditForm
=
"true"
>
<
FormTemplate
>
<
table
width
=
"100%"
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
Name:
</
td
>
<
td
colspan
=
"3"
>
<
telerik:RadTextBox
ID
=
"RadTextBox_Name"
runat
=
"server"
width
=
"100%"
Text='<%# Bind("Name" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
NDC:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadTextBox
ID
=
"RadTextBox_NDC"
runat
=
"server"
width
=
"100%"
Text='<%# Bind("NDC" ) %>' />
</
td
>
<
td
width
=
"10%"
align
=
"right"
>
Approval Date:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadDateInput
ID
=
"RadDateInput_ApprovalDate"
runat
=
"server"
Width
=
"100%"
DBSelectedDate='<%# Bind("ApprovalDate" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
NDC2:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadTextBox
ID
=
"RadTextBox_NDC2"
runat
=
"server"
width
=
"100%"
Text='<%# Bind("NDC2" ) %>' />
</
td
>
<
td
width
=
"10%"
align
=
"right"
>
Intro Date:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadDateInput
ID
=
"RadDateInput_IntroDate"
runat
=
"server"
Width
=
"100%"
DBSelectedDate='<%# Bind("IntroductionDate" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
Form:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadComboBox
ID
=
"RadComboBox_Form"
runat
=
"server"
width
=
"100%"
DataSourceID
=
"SqlDataSource_Form"
DataTextField
=
"Code"
DataValueField
=
"RowGUID_Key"
SelectedValue='<%# Bind("Form_GUID" ) %>' />
</
td
>
<
td
width
=
"10%"
align
=
"right"
>
Term Date:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadDateInput
ID
=
"RadDateInput_TermDate"
runat
=
"server"
Width
=
"100%"
DbSelectedDate='<%# Bind("TerminationDate" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
UOM:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadComboBox
ID
=
"RadComboBox_UOM"
runat
=
"server"
width
=
"100%"
DataSourceID
=
"SqlDataSource_UOM"
DataTextField
=
"Code"
DataValueField
=
"RowGUID_Key"
SelectedValue='<%# Bind("UOM_GUID" ) %>' />
</
td
>
<
td
width
=
"10%"
align
=
"right"
>
Units/Pkg:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox_UnitsPerPkg"
runat
=
"server"
Width
=
"100%"
Text='<%# Bind("UnitsPerPackage" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
width
=
"10%"
align
=
"right"
>
Product Code:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadTextBox
ID
=
"RadTextBox_ProductCode"
runat
=
"server"
width
=
"100%"
Text='<%# Bind("ProductCode" ) %>' />
</
td
>
<
td
width
=
"10%"
align
=
"right"
>
Finance Product Code:
</
td
>
<
td
width
=
"40%"
>
<
telerik:RadTextBox
ID
=
"RadTextBox_FinanceProductCode"
runat
=
"server"
width
=
"100%"
Text='<%# Bind("Finance_ProductCode" ) %>' />
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
>
<
telerik:RadTabStrip
ID
=
"RadTabStrip_Pricing"
runat
=
"server"
Width
=
"100%"
MultiPageID
=
"RadMultiPage_Pricing"
SelectedIndex
=
"0"
>
<
Tabs
>
<
telerik:RadTab
runat
=
"server"
Text
=
"WAC Pricing"
Selected
=
"true"
/>
<
telerik:RadTab
runat
=
"server"
Text
=
"AMP Pricing"
/>
<
telerik:RadTab
runat
=
"server"
Text
=
"BAS Pricing"
/>
<
telerik:RadTab
runat
=
"server"
Text
=
"CMS Pricing"
/>
</
Tabs
>
</
telerik:RadTabStrip
>
<
telerik:RadMultiPage
ID
=
"RadMultiPage_Pricing"
runat
=
"server"
SelectedIndex
=
"0"
>
<
telerik:RadPageView
ID
=
"RadPageView_WAC"
runat
=
"server"
>
<
telerik:RadGrid
ID
=
"Inherit"
DataKeyNames
=
"RowGUID_Key"
DataSourceID
=
"SqlDataSource_WAC"
Width
=
"100%"
runat
=
"server"
Name
=
"WAC"
OnItemCommand
=
"Inherit_ItemCommand"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
GridLines
=
"None"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
>
<
MasterTableView
DataSourceID
=
"SqlDataSource_WAC"
DataKeyNames
=
"RowGUID_Key, Product_GUID"
EditMode
=
"InPlace"
CommandItemDisplay
=
"TopAndBottom"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"Product_GUID"
MasterKeyField
=
"RowGUID_Key"
/>
</
ParentTableRelation
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn_WAC"
/>
<
telerik:GridBoundColumn
DataField
=
"EffectiveDate"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter EffectiveDate column"
HeaderText
=
"EffectiveDate"
SortExpression
=
"EffectiveDate"
UniqueName
=
"EffectiveDate"
DataFormatString
=
"{0:d}"
/>
<
telerik:GridBoundColumn
DataField
=
"StartDate"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter StartDate column"
HeaderText
=
"StartDate"
SortExpression
=
"StartDate"
UniqueName
=
"StartDate"
DataFormatString
=
"{0:d}"
/>
<
telerik:GridBoundColumn
DataField
=
"EndDate"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter EndDate column"
HeaderText
=
"EndDate"
SortExpression
=
"EndDate"
UniqueName
=
"EndDate"
DataFormatString
=
"{0:d}"
/>
<
telerik:GridBoundColumn
DataField
=
"Price"
DataType
=
"System.Decimal"
FilterControlAltText
=
"Filter Price column"
HeaderText
=
"Price"
SortExpression
=
"Price"
UniqueName
=
"Price"
DataFormatString
=
"{0:C2}"
/>
</
Columns
>
<
EditFormSettings
EditColumn-UniqueName
=
"EditCommandColumn_WAC"
EditColumn-ButtonType
=
"ImageButton"
EditFormType
=
"AutoGenerated"
/>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadPageView
>
<
telerik:RadPageView
ID
=
"RadPageView_AMP"
runat
=
"server"
>
</
telerik:RadPageView
>
<
telerik:RadPageView
ID
=
"RadPageView_BAS"
runat
=
"server"
>
</
telerik:RadPageView
>
<
telerik:RadPageView
ID
=
"RadPageView_CMS"
runat
=
"server"
>
</
telerik:RadPageView
>
</
telerik:RadMultiPage
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
>
<
br
/>
<
asp:Button
ID
=
"btnUpdate"
Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'/>
<
asp:Button
ID
=
"btnCancel"
Text
=
"Cancel"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
/>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
</
EditFormSettings
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
asp:Content
>