Hi ,
Not able to figure out the way to format numeric fields.
Code snippet
Dim ColStyle3 As New DataGridTextBoxColumn
With ColStyle3
..MappingName = "TargetQty"
..HeaderText = "Target"
..NullText = "0"
..TextBox.MaxLength = QTYMAXLENGTH (eg. 7)
..Alignment = HorizontalAlignment.Right
..Format = CommonDefinition.CUST_QTY_FORMAT (eg. "###,###,###.00" )
End With
grdTableStyle1.GridColumnStyles.Add(ColStyle3)
This is working fine when the regional Options
General Tab
Your Locale(location) is set to english (United states)
Numbers Tab
digit grouping 123,456,789
Not working in case of
General Tab
Your Locale(location) is set to english (United states)
Numbers Tab
digit grouping 123456789 (without commas)
In this case what is the solution . Application should not take regional
options settings , instead it should take what custom format is done through
configuration file.
================================================== ===================
OR This code is not working when we change regional options number formats
(digit grouping) option
================================================== ===================
' Displays the Numeric formatting examples.
Private Sub LoadNumericFormats()
Dim intNumber As Int32 = 1234567890
Dim sb As New StringBuilder()
strCultureValue = cboCultureInfoNumeric.SelectedValue.ToString
Thread.CurrentThread.CurrentCulture = New CultureInfo(strCultureValue)
sb.Append("When using " & strCultureValue & " CultureInfo, the Integer
1234567890 will format as follows:")
sb.Append(crlf)
sb.Append(crlf)
If optStandardNumeric.Checked Then
With sb
..Append(intNumber.ToString("C"))
..Append(" [Currency]")
..Append(crlf)
..Append(intNumber.ToString("E"))
..Append(" [Scientific (Exponential)]")
..Append(crlf)
..Append(intNumber.ToString("P"))
..Append(" [Percent]")
..Append(crlf)
..Append(intNumber.ToString("N"))
..Append(" [Number]")
..Append(crlf)
..Append(intNumber.ToString("F"))
..Append(" [Fixed-point]")
..Append(crlf)
..Append(intNumber.ToString("X"))
..Append(" [Hexadecimal]")
..Append(crlf)
..Append(crlf)
End With
ElseIf optCustomNumeric.Checked Then
With sb
..Append(intNumber.ToString("###,##"))
..Append(" [###,##]")
..Append(crlf)
..Append(intNumber.ToString("00000"))
..Append(" [00000]")
..Append(crlf)
..Append(intNumber.ToString("(###) ### - ####"))
..Append(" [(###) ### - ##,##]")
..Append(crlf)
..Append(intNumber.ToString("#.##"))
..Append(" [#.##]")
..Append(crlf)
..Append(intNumber.ToString("00.00"))
..Append(" [00.00]")
..Append(crlf)
..Append(intNumber.ToString("#,#"))
..Append(" [#,#]")
..Append(crlf)
..Append(intNumber.ToString("#,,"))
..Append(" [#,,]")
..Append(crlf)
..Append(intNumber.ToString("#.##"))
..Append(" [#.##]")
..Append(crlf)
..Append(intNumber.ToString("#,,,"))
..Append(" [#,,,]")
..Append(crlf)
..Append(intNumber.ToString("#,##0,,"))
..Append(" [#,##0,,]")
..Append(crlf)
..Append(intNumber.ToString("#0.##%"))
..Append(" [#0.##%]")
..Append(crlf)
..Append(intNumber.ToString("0.###E+000"))
..Append(" [0.###E+000]")
..Append(crlf)
..Append(intNumber.ToString("##;(##)"))
..Append(" [##;(##)]")
..Append(crlf)
End With
End If
txtNumeric.Text = sb.ToString
End Sub
Thanks.
Narayan.
Thanks.
Narayan.