or
Dear Team,
I am using Rad Grid then I binded some fileds in Existing Table.after given text box this calculated filed. Give correct solution for java script.
With Regards,
S.kannadasan
DataRow[] changedRows = usersTable.Select(editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["GUID"].ToString());<telerik:RadGrid ID="ResellerGrid" ShowStatusBar="true" runat="server" AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True" GridLines="None" OnDetailTableDataBind="ResellerGrid_DetailTableDataBind" OnNeedDataSource="ResellerGrid_NeedDataSource" OnPreRender="ResellerGrid_OnPreRender"> <MasterTableView DataKeyNames="ResellerPriceId,ProductId" ShowFooter="true" AllowMultiColumnSorting="True" HierarchyDefaultExpanded="False"> <DetailTables> <telerik:GridTableView DataKeyNames="ProductId" Width="100%" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="ResellerPriceId" MasterKeyField="ResellerPriceId" /> </ParentTableRelation> <NoRecordsTemplate> No data</NoRecordsTemplate> <Columns> <telerik:GridTemplateColumn UniqueName="ProductNameTemplateColumn" HeaderText="Product Name"> <ItemTemplate> <asp:Label runat="server" ID="lblProductName" Text='<%#Eval("ProductName") %>'/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="chkScaledTemplateColumn" HeaderText="Is Scaled"> <ItemTemplate> <asp:CheckBox runat="server" ID="chkScaled" OnCheckedChanged="chkScaled_OnCheckedChanged" Checked='<%#Eval("IsScaled") %>' AutoPostBack="true"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtCostTemplateColumn" HeaderText="Cost Price"> <ItemTemplate> <asp:TextBox runat="server" ID="txtCost" Text='<%#ToCurrency(Eval("CostPrice")) %>' /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtMarkUpTemplateColumn" HeaderText="MarkUp"> <ItemTemplate> <asp:TextBox runat="server" ID="txtMarkUp" Width="100px" OnTextChanged="txtMarkUp_OnLeave" Text='<%#Eval("MarkUp") %>' AutoPostBack="true" />% <asp:RegularExpressionValidator ID="regMarkUp" ControlToValidate="txtMarkUp" ErrorMessage="Incorrect Percentage" runat="server" ValidationExpression='<%$ Resources:ValidationPatterns, Decimal %>'>[Invalid]</asp:RegularExpressionValidator> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtFinalCostTemplateColumn" HeaderText="Final Cost"> <ItemTemplate> <asp:TextBox runat="server" ID="txtFinalCost" OnTextChanged="txtFinalCost_OnLeave" Text='<%#ToCurrency(Eval("FinalPrice")) %>' Align="Right" AutoPostBack="true"/> <asp:RegularExpressionValidator ID="regFinalCost" ControlToValidate="txtFinalCost" ErrorMessage="Incorrect Final Price" runat="server" ValidationExpression='<%$ Resources:ValidationPatterns,Decimal %>'>[Invalid]</asp:RegularExpressionValidator> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="chkScaledTemplateColumn" HeaderText="Is Available"> <ItemTemplate> <asp:CheckBox runat="server" ID="chkAvail" OnCheckedChanged="chkAvail_OnCheckedChanged" Checked='<%#Eval("IsAvailable") %>' AutoPostBack="true"/> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridTemplateColumn UniqueName="ProductNameTemplateColumn" HeaderText="Product Name"> <ItemTemplate> <asp:Label runat="server" ID="lblProductName" Text='<%#Eval("ProductName") %>'/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtCostTemplateColumn" HeaderText="Cost Price"> <ItemTemplate> <asp:TextBox runat="server" ID="txtCost" Text='<%#ToCurrency(Eval("CostPrice")) %>'/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtMarkUpTemplateColumn" HeaderText="MarkUp"> <ItemTemplate> <asp:TextBox runat="server" ID="txtMarkUp" Width="100px" OnTextChanged="txtTypeMarkUp_OnTextChanged" Text='<%#Eval("MarkUp") %>' AutoPostBack="true"/> <asp:RegularExpressionValidator ID="regMarkUp" ControlToValidate="txtMarkUp" ErrorMessage="Incorrect Percentage" runat="server" ValidationExpression='<%$ Resources:ValidationPatterns, Decimal %>'>[Invalid]</asp:RegularExpressionValidator> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="txtFinalCostTemplateColumn" HeaderText="Final Cost" > <ItemTemplate> <asp:TextBox runat="server" ID="txtFinalCost" OnTextChanged="txtTypeFinalCost_OnTextChanged" Text='<%#ToCurrency(Eval("FinalPrice")) %>' AutoPostBack="true"/> <asp:RegularExpressionValidator ID="regFinalCost" ControlToValidate="txtFinalCost" ErrorMessage="Incorrect Final Price" runat="server" ValidationExpression='<%$ Resources:ValidationPatterns, Decimal %>'>[Invalid]</asp:RegularExpressionValidator> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid>| <CommandItemTemplate> |
| <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/Update.gif" runat="server" /> Update Activity |
| </asp:LinkButton> |
| <telerik:RadGrid ID="RadGrid1" Skin="DWDS" EnableEmbeddedSkins="false" ImagesPath="~/Skins/DWDS/Grid/" runat="server" Width="100%" PageSize="14" |
| AllowAutomaticDeletes="true" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" |
| AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" ShowStatusBar="true" AllowSorting="true" ShowFooter="true" AllowFilteringByColumn="true" > |
| <PagerStyle Mode="NextPrevNumericAndAdvanced" /> |
| <ExportSettings FileName="DeepWellData File Export" /> |
| <MasterTableView CommandItemDisplay="Top" CurrentResetPageIndexAction="SetPageIndexToFirst" ShowHeadersWhenNoRecords="true" DataKeyNames="Activity_ID" DataSourceID="SqlDataSource1" Width="100%" AutoGenerateColumns="false" EditMode="EditForms"> |
| <CommandItemTemplate> |
| <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/Update.gif" runat="server" /> Update Activity |
| </asp:LinkButton> |
| |
| <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/Cancel.gif" runat="server" /> Cancel editing |
| </asp:LinkButton> |
| |
| <asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/AddRecord.gif" runat="server" /> Add new Activity</asp:LinkButton> |
| <asp:LinkButton ID="LinkButton3" runat="server" CommandName="PerformInsert" Visible='<%# RadGrid1.MasterTableView.IsItemInserted %>'> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/Insert.gif" runat="server" /> Add this Activity</asp:LinkButton> |
| |
| <asp:LinkButton ID="LinkButton4" runat="server" CommandName="RebindGrid"> |
| <img style="border:0px" alt="" src="~/Skins/DWDS/Grid/Refresh.gif" runat="server" /> Refresh Activity list |
| </asp:LinkButton> |
| |
| <asp:Label ID="lblCategoryEdit" Visible="false" OnDataBinding="DisableCategoryEdit" runat="server"> |
| <telerik:RadWindowManager ID="RadWindowManager2" runat="server" Height="500px" Width="480px" Modal="true"> |
| <Windows> |
| <telerik:RadWindow OpenerElementID="aRegion" Width="480px" Height="450px" NavigateUrl="~/Projects/CaseFiles/AddRecord/Category.aspx" ID="RadWindow1" runat="server" /> |
| </Windows> |
| </telerik:RadWindowManager> |
| <a id="aRegion" style="cursor: pointer;"> |
| <img src="~/Skins/DWDS/Grid/Edit.gif" runat="server" border="0" alt="Edit Categories" />Add/Edit Categories</a> </asp:Label> |
| <br /> |
| |
| </CommandItemTemplate> |
| <Columns> |
| <telerik:GridEditCommandColumn ButtonType="ImageButton" EditImageUrl="~\Skins\DWDS\Grid\Edit.gif" |
| UniqueName="EditColumn"> |
| <HeaderStyle Width="25px" /> |
| <ItemStyle HorizontalAlign="Center" Width="25px" /> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridButtonColumn ConfirmText="Delete this activity?" ButtonType="ImageButton" ImageUrl="~\Skins\DWDS\Grid\Delete.gif" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"> |
| <HeaderStyle Width="25px" /> |
| <ItemStyle HorizontalAlign="Center" Width="25px" /> |
| </telerik:GridButtonColumn> |
| <telerik:GridBoundColumn DataField="Activity_ID" HeaderText="ID" ReadOnly="True" SortExpression="Name" UniqueName="Activity_ID" Visible="False" /> |
| <telerik:GridBoundColumn DataField="Name" HeaderText="Activity Name" ColumnEditorID="GridTextBoxColumnEditor1" SortExpression="Name" UniqueName="name" /> |
| <telerik:GridBoundColumn DataField="PName" HeaderText="Partner" ReadOnly="True" Display="true" SortExpression="PName" UniqueName="PName" /> |
| <telerik:GridBoundColumn DataField="Category_Name" HeaderText="Category" ReadOnly="True" Display="true" SortExpression="Category_Name" UniqueName="Category_Name" /> |
| <telerik:GridDropDownColumn DataField="Partner_ID" ColumnEditorID="GridDropDownListColumnEditor1" DataSourceID="SqlDataSource2" HeaderText="Partner" ListTextField="Name" ListValueField="Partner_ID" |
| UniqueName="pid" Display="false" /> |
| <telerik:GridDropDownColumn DataField="Category_ID" ColumnEditorID="GridDropDownListColumnEditor2" DataSourceID="SqlDataSource3" HeaderText="Category" ListTextField="Name" ListValueField="Category_ID" |
| UniqueName="cid" Display="false" /> |
| <telerik:GridDropDownColumn DataField="Goal_Number" ColumnEditorID="GridDropDownListColumnEditor3" DataSourceID="SqlDataSource7" Visible="false" HeaderText="Goal #" ListTextField="Goal" |
| ListValueField="Goal" UniqueName="Goal_number" /> |
| <telerik:GridNumericColumn DataField="Completion_Hours" Visible="false" HeaderText="Completion Hours (in Minutes)" ColumnEditorID="GridNumericColumnEditor1" SortExpression="Completion_Hours" |
| UniqueName="Completion_Hours" /> |
| <telerik:GridTemplateColumn HeaderText="Details" AllowFiltering="false" DataField="Activity_ID" UniqueName="viewActivity"> |
| <ItemTemplate> |
| <div style="text-align: center"> |
| <asp:ImageButton ID="showItem" OnClick="showActivityDetails_Click" runat="server" ImageUrl="~/Images/Icons/magnifier.gif" CommandName="viewingActivity" CommandArgument='<%# Eval("Activity_ID") %>' /> |
| </div> |
| </ItemTemplate> |
| <FooterTemplate> |
| <div style="font-size: 11px; color: #5e7ca7; padding-top: 2px"> |
| Export to:<br /> |
| <asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/Images/Icons/excel.gif" AlternateText="Export to excel" OnClick="btnExcel_Click" /> |
| <asp:ImageButton ID="btnWord" runat="server" ImageUrl="~/Images/Icons/word.gif" AlternateText="Export to word" OnClick="btnWord_Click" /> |
| </div> |
| </FooterTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridHTMLEditorColumn Visible="false" DataField="Notes" ColumnEditorID="GridHTMLEditorColumnEditor1" HeaderText="Notes" SortExpression="Notes" UniqueName="Notes" /> |
| <telerik:GridBoundColumn Visible="false" DataField="Partner_ID" UniqueName="Partner_ID" ReadOnly="true" /> |
| <telerik:GridBoundColumn DataField="PName" Visible="false" UniqueName="PName2" ReadOnly="true" /> |
| </Columns> |
| <EditFormSettings CaptionDataField="Name" CaptionFormatString="Edit properties of Activity: {0}" ColumnNumber="1"> |
| <FormTableItemStyle Wrap="False" Width="400px"></FormTableItemStyle> |
| <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle> |
| <FormMainTableStyle GridLines="Horizontal" CellSpacing="10" CellPadding="10" BackColor="White" /> |
| <FormTableStyle CellSpacing="10" CellPadding="10" CssClass="module" Height="150px" BackColor="White" /> |
| <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle> |
| <FormStyle Width="10%"></FormStyle> |
| <EditColumn ButtonType="ImageButton" UpdateImageUrl="~\Skins\DWDS\Grid\Update.gif" EditImageUrl="~\Skins\DWDS\Grid\Edit.gif" InsertImageUrl="~\Skins\DWDS\Grid\Insert.gif" CancelImageUrl="~\Skins\DWDS\Grid\Cancel.gif" |
| InsertText="Insert Activity" UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit"> |
| </EditColumn> |
| <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle> |
| </EditFormSettings> |
| <ExpandCollapseColumn Visible="False"> |
| <HeaderStyle Width="19px" /> |
| </ExpandCollapseColumn> |
| <RowIndicatorColumn Visible="False"> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| </MasterTableView> |
| </telerik:RadGrid> |