Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
665
Formatting column and EdittorProvider
posted

Hello,

I have two questions about formatting column.

1/ Percent format

    - I have a column needs format percent. I used DataFormatString="{0:P2}" for this column. When I enter "30.45" to a cell and exit edit mode, the cell displayed "3045.00%". I don't want this cell multiply to 100 auto.

2/ Currency editor

   - I have set DataFormatString="{0:C2}" and used CurrencyEditorProvider for this column. When load data, cell displayed "500$" but when I click to cell to edit, the cell displayed "0" and I can't get value of cell by client.

How to solve its?

Parents
  • 665
    posted

    I forget provide my aspx file. I'm using NetAdvantage version 14.1.20141.2011 latest release. This is my code:

    <ig:WebDataGrid ID="UG_PricingTiers" runat="server" Height="175px" Width="100%" AutoGenerateColumns="False" EnableDataViewState="True"
    DataKeyFields="ID" EnableAjax="False" Font-Bold="False">
    <Columns>
    <ig:BoundDataField DataFieldName="SRVC_Ledger_Tier_Code_Type_Lkup_ID" Key="SRVC_Ledger_Tier_Code_Type_Lkup_ID" Width="5%" CssClass="ReadOnlyTextLeft">
    <Header Text="Tier ID" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField CssClass="ReadOnlyTextLeft" DataFieldName="SRVC_Terms_Tier_Type_Lkup_ID" Key="SRVC_Terms_Tier_Type_Lkup_ID" Width="15%">
    <Header Text="Tier Type" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Tier_Threshold_Amt" Key="Tier_Threshold_Amt" Width="10%" DataFormatString="{0:C2}"
    CssClass="ReadOnlyTextRight" DataType="System.String">
    <Header Text="Tier Threshold Amount" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Effective_Dt" Key="Effective_Dt" Width="10%" CssClass="ReadOnlyTextLeft" DataType="System.DateTime">
    <Header Text="Effective Date" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Common_Int_Index_Lkup_ID" Key="Common_Int_Index_Lkup_ID" Width="15%" CssClass="ReadOnlyTextLeft" DataType="System.Object">
    <Header Text="Pricing Index" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Rate_Pct" Key="Interest_Rate_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight">
    <Header Text="Rate" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Floor_Pct" Key="Interest_Floor_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight">
    <Header Text="Floor" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Ceiling_Pct" Key="Interest_Ceiling_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight">
    <Header Text="Ceiling" CssClass="NormalTextCenter"></Header>
    <Footer CssClass="NormalTextCenter"></Footer>
    </ig:BoundDataField>
    <ig:BoundDataField DataFieldName="ID" Key="ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="SRVC_FixedFloat_Type_Lkup_ID" Key="SRVC_FixedFloat_Type_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Common_Accrl_Basis_Code_Lkup_ID" Key="Common_Accrl_Basis_Code_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="SRVC_Interest_Rate_Change_Frequency_Type_Lkup_ID" Key="SRVC_Interest_Rate_Change_Frequency_Type_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="SRVC_Terms_Rate_Change_Apply_Lkup_ID" Key="SRVC_Terms_Rate_Change_Apply_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="SRVC_Arms_Plan_Type_Lkup_ID" Key="SRVC_Arms_Plan_Type_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="SRVC_Terms_Default_Rate_Plan_Type_Lkup_ID" Key="SRVC_Terms_Default_Rate_Plan_Type_Lkup_ID" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Index_Release_1_Pct" Key="Interest_Index_Release_1_Pct" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Index_Release_2_Pct" Key="Interest_Index_Release_2_Pct" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Relationship_Code_1" Key="Interest_Relationship_Code_1" Hidden="True"></ig:BoundDataField>
    <ig:BoundDataField DataFieldName="Interest_Relationship_Code_2" Key="Interest_Relationship_Code_2" Hidden="True"></ig:BoundDataField>
    <ig:UnboundField Hidden="True" Key="Status" />
    <ig:UnboundField Key="uSRVC_Ledger_Tier_Code_Type_Lkup_ID" Hidden="True"></ig:UnboundField>
    <ig:UnboundField Key="uSRVC_Terms_Tier_Type_Lkup_ID" Hidden="True"></ig:UnboundField>
    <ig:UnboundField Key="uTier_Threshold_Amt" Hidden="True"></ig:UnboundField>
    <ig:UnboundField Key="uCommon_Int_Index_Lkup_ID" Hidden="True"></ig:UnboundField>
    </Columns>
    <EditorProviders>
    <ig:DropDownProvider ID="Ledger_Tier_Code_Provider" StretchHeight="False">
    <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False"
    DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px">
    <ClientEvents DropDownOpening="DropDownProvider_Opening" />
    </EditorControl>
    </ig:DropDownProvider>
    <ig:DropDownProvider ID="SRVC_Terms_Tier_Type_Provider" StretchHeight="False">
    <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False"
    DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px">
    <ClientEvents DropDownOpening="DropDownProvider_Opening" />
    </EditorControl>
    </ig:DropDownProvider>
    <ig:DropDownProvider ID="Common_Int_Index_Prodiver" StretchHeight="False">
    <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False"
    DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px">
    <ClientEvents DropDownOpening="DropDownProvider_Opening" />
    </EditorControl>
    </ig:DropDownProvider>
    <ig:DatePickerProvider ID="Effective_Dt_PricingTiers_Provider">
    <EditorControl runat="server" EditModeFormat="MM/dd/yyyy" EnableViewState="true">
    </EditorControl>
    </ig:DatePickerProvider>
    <ig:CurrencyEditorProvider ID="TB_Currency_PricingTiers">
    <EditorControl runat="server" CssClass="TextRight" MaxLength="10" MinDecimalPlaces="2">
    </EditorControl>
    </ig:CurrencyEditorProvider>
    <ig:PercentEditorProvider ID="TB_Percent_PricingTiers">
    <EditorControl runat="server" CssClass="TextRight" MaxLength="10" MinDecimalPlaces="5">
    </EditorControl>
    </ig:PercentEditorProvider>
    </EditorProviders>
    <Behaviors>
    <ig:EditingCore BatchUpdating="True">
    <Behaviors>
    <ig:CellEditing Enabled="true" EditCellCssClass="NormalText">
    <ColumnSettings>
    <ig:EditingColumnSetting ColumnKey="SRVC_Ledger_Tier_Code_Type_Lkup_ID" EditorID="Ledger_Tier_Code_Provider" />
    <ig:EditingColumnSetting ColumnKey="SRVC_Terms_Tier_Type_Lkup_ID" EditorID="SRVC_Terms_Tier_Type_Provider" />
    <ig:EditingColumnSetting ColumnKey="Common_Int_Index_Lkup_ID" EditorID="Common_Int_Index_Prodiver" />
    <ig:EditingColumnSetting ColumnKey="Effective_Dt" EditorID="Effective_Dt_PricingTiers_Provider" />
    <ig:EditingColumnSetting ColumnKey="Tier_Threshold_Amt" EditorID="TB_Currency_PricingTiers" />
    <ig:EditingColumnSetting ColumnKey="Interest_Rate_Pct" EditorID="TB_Percent_PricingTiers" />
    <ig:EditingColumnSetting ColumnKey="Interest_Floor_Pct" EditorID="TB_Percent_PricingTiers" />
    <ig:EditingColumnSetting ColumnKey="Interest_Ceiling_Pct" EditorID="TB_Percent_PricingTiers" />
    </ColumnSettings>
    <CellEditingClientEvents EnteringEditMode="UG_PricingTiers_CellEditing_EnteringEditMode" />
    <EditModeActions MouseClick="Single" EnableOnActive="True" />
    </ig:CellEditing>
    </Behaviors>
    </ig:EditingCore>
    <ig:Sorting Enabled="true">
    <SortingClientEvents ColumnSorting="" />
    </ig:Sorting>
    <ig:Activation Enabled="true">
    <ActivationClientEvents ActiveCellChanging="" />
    </ig:Activation>
    <ig:Selection CellClickAction="Cell" RowSelectType="Single" Enabled="true">
    </ig:Selection>
    <ig:RowSelectors Enabled="True" RowNumbering="False" EnableInheritance="True">
    <RowSelectorClientEvents RowSelectorClicked="UG_PricingTiers_RowSelector_RowSelectorClicked" />
    </ig:RowSelectors>
    <ig:Paging PagerAppearance="Bottom" PageSize="6" Enabled="false" QuickPages="9" />
    <ig:ColumnResizing>
    <ColumnSettings>
    <ig:ColumnResizeSetting />
    </ColumnSettings>
    </ig:ColumnResizing>
    </Behaviors>
    </ig:WebDataGrid>

Reply Children
No Data