Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird behavior on localization
Message
From
03/08/2010 02:59:35
 
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01474524
Message ID:
01474929
Views:
31
I have adjusted and it works. This is what I have now:
        ' Format a value
        ' expN1 Value
        ' expC1 Separator
        ' expN2 Number of decimals
        Public Function GetFormatValue(ByVal tnValue As Double, ByVal tcSeparator As String, _
         ByVal tnDecimal As Integer) As String
            Dim lcValue As String = ""
            Dim loCultureInfo As CultureInfo = Nothing

            ' Based on the language
            Select Case nLanguage

                ' English
                Case 1
                    loCultureInfo = New CultureInfo("en-US")

                    ' French
                Case 2
                    loCultureInfo = New CultureInfo("fr-CA")

                    ' Spanish
                Case 3
                    loCultureInfo = New CultureInfo("en-US")

                    ' Portuguese
                Case 4
                    loCultureInfo = New CultureInfo("en-US")

            End Select

            loCultureInfo.NumberFormat.NumberDecimalSeparator = "."
            loCultureInfo.NumberFormat.NumberGroupSeparator = tcSeparator
            loCultureInfo.NumberFormat.NumberDecimalDigits = tnDecimal

            lcValue = tnValue.ToString("N", loCultureInfo)

            Return lcValue
        End Function

        ' Format a value for a dollar
        ' expN1 Value
        ' expC1 Separator
        Public Function GetFormatValueDollar(ByVal tnValue As Double, ByVal tcSeparator As String) As String
            Dim loCultureInfo As CultureInfo = Nothing
            Dim lcValue As String = ""

            ' Based on the language
            Select Case nLanguage

                ' English
                Case 1
                    loCultureInfo = New CultureInfo("en-US")

                    ' French
                Case 2
                    loCultureInfo = New CultureInfo("fr-CA")

                    ' Spanish
                Case 3
                    loCultureInfo = New CultureInfo("en-US")

                    ' Portuguese
                Case 4
                    loCultureInfo = New CultureInfo("en-US")

            End Select

            loCultureInfo.NumberFormat.CurrencyDecimalSeparator = "."
            loCultureInfo.NumberFormat.CurrencyGroupSeparator = tcSeparator

            ' If we format the dollar sign as per the language
            If oApp.lFormatDollarAsPerTheLanguage Then

                ' Based on the language
                Select Case nLanguage

                    ' English
                    Case 1

                        ' French
                    Case 2
                        loCultureInfo.NumberFormat.CurrencyPositivePattern = 1

                        ' Spanish
                    Case 3

                        ' Portuguese
                    Case 4

                End Select

            End If

            lcValue = tnValue.ToString("C", loCultureInfo)

            Return lcValue
        End Function
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform