I have a grid, and in that grid in edit mode, I have fields - among those a price field, a template which is combo box and a template which is another grid. When the user drops down the combo box and chooses a package, the embedded grid redraws from the selection of the combo box. One of the columns in the embedded grid is the package price, and every row is the same and I hide it in embedded grid, but I would like to take that value, and every time the user chooses from the combo box, I want to take that price and put it in the price field on the main grid. I am trying to do it the selected index changed code behind when the combo box is changed, but there is nothing there telling me about the main grid(usersGrid). Also, on insert, the combo box defaults to the first choice, and the embedded grid is there by default. How can I populate the price field in the main grid from the embedded grid on opening of the form?
Here is my code:
ASPX:
<telerik:RadGrid ID="usersGrid" runat="server"
DataSourceID="ContentCentralUsers" GridLines="None" Skin="Office2007" AutoGenerateColumns="False"
ondatabound="usersGrid_DataBound" onitemdatabound="usersGrid_ItemDataBound"
onitemevent="usersGrid_ItemDataBound" oniteminserted="usersGrid_ItemInserted" onitemupdated="usersGrid_ItemUpdated"
ShowStatusBar="True" OnPreRender="usersGrid_PreRender" oninsertcommand="usersGrid_InsertCommand" OnItemCommand="usersGrid_ItemCommand"
onupdatecommand="usersGrid_UpdateCommand" commanditemdisplay="TopAndBottom">
<MasterTableView DataSourceID="ContentCentralUsers"
AllowFilteringByColumn="True" AllowSorting="True"
InsertItemPageIndexAction="ShowItemOnFirstPage" CommandItemDisplay="Top"
NoMasterRecordsText="No users to display.">
<CommandItemSettings AddNewRecordText="Add new user" />
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1">
<HeaderStyle Width="20px" />
</telerik:GridEditCommandColumn>
<telerik:GridBoundColumn DataField="user_id" UniqueName="user_id" Visible="false" ReadOnly="true" ></telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Seat(User)" SortExpression="login_name" UniqueName="login_name" >
<ItemTemplate>
<asp:Label ID="login_name" runat="server" Text='<%#Eval("login_name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox Text='<%#Eval("login_name") %>' runat="server" OnTextChanged="change_loginName"></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Password" SortExpression="password" UniqueName="password" EditFormColumnIndex="1" AllowFiltering="false">
<ItemTemplate>
<asp:Label ID="password" runat="server" Text='<%#Eval("password") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" Text='<%#Eval("password") %>' runat="server" OnTextChanged="change_Password" ></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Email" SortExpression="email" UniqueName="email" >
<ItemTemplate>
<asp:Label ID="email" runat="server" Text='<%#Eval("email") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" Text='<%#Eval("email") %>' runat="server" OnTextChanged="change_email"></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Package" UniqueName="RadComboPackage" EditFormColumnIndex="1" >
<HeaderStyle Width="100%" />
<ItemTemplate>
<asp:Label runat="server" ID="Label1" Text='<%#Eval("package_name") %>'></asp:Label>
<telerik:RadToolTip runat="server" ID="RadToolTip1" TargetControlID="Label1"
Skin="Office2007" ShowDelay="1000" AutoCloseDelay="200000" Font-Names="arial"
Font-Size="XX-Large" BorderStyle="Inset" HideDelay="100000" ManualClose="False"
Position="BottomRight" Sticky="True" Width="300">
<asp:Label runat="server" ID="Label3" Text='<%#Eval("descriptions") %>'></asp:Label><br/>
</telerik:RadToolTip>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadComboBox ID="package" Width="220px" runat="server" OnSelectedIndexChanged="RadComboBoxSelectedIndexChanged"
MarkFirstMatch="True" AllowCustomText="True" DataSourceID="ContentCentralPackages" EmptyMessage="Select a package"
ExpandAnimation-Type="None" CollapseAnimation-Type="None" AutoPostBack="true" AppendDataBoundItems="false"
DataTextField="package_name" DataValueField="package_cd" DropDownWidth="650px"
Skin="Office2007" SelectedValue='<%# Bind("package_cd") %>'
EnableVirtualScrolling="True" HighlightTemplatedItems="True">
<ExpandAnimation Type="None" />
<CollapseAnimation Duration="200" Type="None" />
<HeaderTemplate>
<table style="width: 620px; text-align: left">
<tr>
<td style="width: 170px;">
Package Name
</td>
<td style="width: 450px;" >
Description
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 620px; text-align: left">
<tr>
<td style="width: 170px;" valign="top">
<%# DataBinder.Eval(Container.DataItem, "package_name") %>
</td>
<td style="width: 450px;">
<%# DataBinder.Eval(Container.DataItem, "descriptions") %>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadComboBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="packageprice" HeaderText="Package Price" Display="true" UniqueName="packageprice"
DataFormatString="{0:C2}" ></telerik:GridBoundColumn>
<telerik:GridMaskedColumn DataField="packagealaprice" Mask="$ #####.##" DataFormatString="{0:C2}" HeaderText="Ala Carte Price" Display="true" UniqueName="packagepriceala"
readonly="true" >
<ItemStyle HorizontalAlign="Right" />
</telerik:GridMaskedColumn>
<telerik:GridTemplateColumn EditFormHeaderTextFormat="" HeaderStyle-VerticalAlign="Top" Visible="false" UniqueName="PackagePriceGrid">
<EditItemTemplate>
<telerik:RadGrid ID="PackagePriceGrid" runat="server" AutoGenerateColumns="False" DataSourceID="spAddNewsTradeProduct"
GridLines="None" Skin="Office2007" onitemdatabound="PackagePriceGrid_ItemDataBound" OnItemCommand="PackageGrid_ItemCommand"
ShowStatusBar="True" OnPreRender="PackagePriceGrid_PreRender" >
<MasterTableView CommandItemDisplay="None" EditMode="InPlace" DataKeyNames="service_id,Checked" >
<Columns>
<telerik:GridBoundColumn UniqueName="service_id" DataField="service_id" Visible="false" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="service_name" HeaderText="Default Package" Display="true" UniqueName="service_name" >
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Entitled" UniqueName="CHECKED">
<ItemTemplate>
<asp:CheckBox ID="Entitled" Checked='<%# Eval("Checked") %>' runat="server" />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn Display="false" Visible="false" ReadOnly="true" UniqueName="PKGPRICE" DataField="Price">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</EditItemTemplate>
<HeaderStyle VerticalAlign="Top"></HeaderStyle>
</telerik:GridTemplateColumn>
Here is my code:
ASPX:
<telerik:RadGrid ID="usersGrid" runat="server"
DataSourceID="ContentCentralUsers" GridLines="None" Skin="Office2007" AutoGenerateColumns="False"
ondatabound="usersGrid_DataBound" onitemdatabound="usersGrid_ItemDataBound"
onitemevent="usersGrid_ItemDataBound" oniteminserted="usersGrid_ItemInserted" onitemupdated="usersGrid_ItemUpdated"
ShowStatusBar="True" OnPreRender="usersGrid_PreRender" oninsertcommand="usersGrid_InsertCommand" OnItemCommand="usersGrid_ItemCommand"
onupdatecommand="usersGrid_UpdateCommand" commanditemdisplay="TopAndBottom">
<MasterTableView DataSourceID="ContentCentralUsers"
AllowFilteringByColumn="True" AllowSorting="True"
InsertItemPageIndexAction="ShowItemOnFirstPage" CommandItemDisplay="Top"
NoMasterRecordsText="No users to display.">
<CommandItemSettings AddNewRecordText="Add new user" />
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1">
<HeaderStyle Width="20px" />
</telerik:GridEditCommandColumn>
<telerik:GridBoundColumn DataField="user_id" UniqueName="user_id" Visible="false" ReadOnly="true" ></telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Seat(User)" SortExpression="login_name" UniqueName="login_name" >
<ItemTemplate>
<asp:Label ID="login_name" runat="server" Text='<%#Eval("login_name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox Text='<%#Eval("login_name") %>' runat="server" OnTextChanged="change_loginName"></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Password" SortExpression="password" UniqueName="password" EditFormColumnIndex="1" AllowFiltering="false">
<ItemTemplate>
<asp:Label ID="password" runat="server" Text='<%#Eval("password") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" Text='<%#Eval("password") %>' runat="server" OnTextChanged="change_Password" ></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Email" SortExpression="email" UniqueName="email" >
<ItemTemplate>
<asp:Label ID="email" runat="server" Text='<%#Eval("email") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" Text='<%#Eval("email") %>' runat="server" OnTextChanged="change_email"></asp:TextBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Package" UniqueName="RadComboPackage" EditFormColumnIndex="1" >
<HeaderStyle Width="100%" />
<ItemTemplate>
<asp:Label runat="server" ID="Label1" Text='<%#Eval("package_name") %>'></asp:Label>
<telerik:RadToolTip runat="server" ID="RadToolTip1" TargetControlID="Label1"
Skin="Office2007" ShowDelay="1000" AutoCloseDelay="200000" Font-Names="arial"
Font-Size="XX-Large" BorderStyle="Inset" HideDelay="100000" ManualClose="False"
Position="BottomRight" Sticky="True" Width="300">
<asp:Label runat="server" ID="Label3" Text='<%#Eval("descriptions") %>'></asp:Label><br/>
</telerik:RadToolTip>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadComboBox ID="package" Width="220px" runat="server" OnSelectedIndexChanged="RadComboBoxSelectedIndexChanged"
MarkFirstMatch="True" AllowCustomText="True" DataSourceID="ContentCentralPackages" EmptyMessage="Select a package"
ExpandAnimation-Type="None" CollapseAnimation-Type="None" AutoPostBack="true" AppendDataBoundItems="false"
DataTextField="package_name" DataValueField="package_cd" DropDownWidth="650px"
Skin="Office2007" SelectedValue='<%# Bind("package_cd") %>'
EnableVirtualScrolling="True" HighlightTemplatedItems="True">
<ExpandAnimation Type="None" />
<CollapseAnimation Duration="200" Type="None" />
<HeaderTemplate>
<table style="width: 620px; text-align: left">
<tr>
<td style="width: 170px;">
Package Name
</td>
<td style="width: 450px;" >
Description
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 620px; text-align: left">
<tr>
<td style="width: 170px;" valign="top">
<%# DataBinder.Eval(Container.DataItem, "package_name") %>
</td>
<td style="width: 450px;">
<%# DataBinder.Eval(Container.DataItem, "descriptions") %>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadComboBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="packageprice" HeaderText="Package Price" Display="true" UniqueName="packageprice"
DataFormatString="{0:C2}" ></telerik:GridBoundColumn>
<telerik:GridMaskedColumn DataField="packagealaprice" Mask="$ #####.##" DataFormatString="{0:C2}" HeaderText="Ala Carte Price" Display="true" UniqueName="packagepriceala"
readonly="true" >
<ItemStyle HorizontalAlign="Right" />
</telerik:GridMaskedColumn>
<telerik:GridTemplateColumn EditFormHeaderTextFormat="" HeaderStyle-VerticalAlign="Top" Visible="false" UniqueName="PackagePriceGrid">
<EditItemTemplate>
<telerik:RadGrid ID="PackagePriceGrid" runat="server" AutoGenerateColumns="False" DataSourceID="spAddNewsTradeProduct"
GridLines="None" Skin="Office2007" onitemdatabound="PackagePriceGrid_ItemDataBound" OnItemCommand="PackageGrid_ItemCommand"
ShowStatusBar="True" OnPreRender="PackagePriceGrid_PreRender" >
<MasterTableView CommandItemDisplay="None" EditMode="InPlace" DataKeyNames="service_id,Checked" >
<Columns>
<telerik:GridBoundColumn UniqueName="service_id" DataField="service_id" Visible="false" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="service_name" HeaderText="Default Package" Display="true" UniqueName="service_name" >
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Entitled" UniqueName="CHECKED">
<ItemTemplate>
<asp:CheckBox ID="Entitled" Checked='<%# Eval("Checked") %>' runat="server" />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn Display="false" Visible="false" ReadOnly="true" UniqueName="PKGPRICE" DataField="Price">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</EditItemTemplate>
<HeaderStyle VerticalAlign="Top"></HeaderStyle>
</telerik:GridTemplateColumn>