• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 742
  • Last Modified:

How do I format a string to display as currency?

Hi, in my application I have a string that I would like to format to display as currency in a text box. I'm setting a variable to a Session on one form and passing it to the next, which is where the text box is located. Is there a way I can do this? I've tried this:

Session("Tuition") = String.Format("{0:C}", vBasicTuition)

but it doesn't seem to work. This is on the first form, and I'm just setting the text box to equal the Session on the second form.  I would really appreciate any help.
0
savache27
Asked:
savache27
  • 4
  • 3
1 Solution
 
Stephen MandersonSoftware EngineerCommented:
Hi there

The following will convert a number string to currency

        Dim vBasicTuition As Integer = Convert.ToInt32("98064")
        Dim s As String = vBasicTuition.ToString("C0", New CultureInfo("en-US"))

Regards
Steve
0
 
Stephen MandersonSoftware EngineerCommented:
Sorry forgot to include CultureInfo requires you to import

Imports System.Globalization

Also I would convert.todecimal not int32 :-)

0
 
savache27Author Commented:
I'm sorry, how can I use this to make the vBasicTuition format as currency. The way you gave it to me worked........but it returned $98, 064. I'm sure you were just using that as an example, but what do I replace that with? I'm including my code for the sub.
Private Sub FindTuition()
 
        Dim OffCampusNotParents(4) As String
        Dim OnCampus(4) As String
        Dim OffCampusWParents(4) As String
        OffCampusNotParents(0) = 3262  '<1/2 time
        OffCampusNotParents(1) = 14644  '1/2 time
        OffCampusNotParents(2) = 15344 '3/4 time
        OffCampusNotParents(3) = 15983 'Full Time
 
        OnCampus(0) = 3262  '<1/2 time
        OnCampus(1) = 12612 '1/2 time
        OnCampus(2) = 13312 '3/4 time
        OnCampus(3) = 13951 'Full Time
 
        OffCampusWParents(0) = 3262  '<1/2 time
        OffCampusWParents(1) = 9610  '1/2 time
        OffCampusWParents(2) = 10310 '3/4 time
        OffCampusWParents(3) = 10949 'Full Time
 
        Dim vBasicTuition As Integer = Convert.ToDecimal("98064")
        Dim s As String = vBasicTuition.ToString("C0", New CultureInfo("en-US"))
        Dim vNonResFee, vClassification, vSemesters
        vClassification = ddHours.SelectedValue
        vNonResFee = 6078 ' amount to add for non-residents
 
   
        If ddHousing.SelectedValue = 1 Then '1 = OnCampus, 2 = OffCampus With Parents, 3 = OffCampus W/O Parents
 
            vBasicTuition = OnCampus(vClassification)
 
        ElseIf ddHousing.SelectedValue = 2 Then
 
            vBasicTuition = OffCampusWParents(vClassification)
        Else
            vBasicTuition = OffCampusNotParents(vClassification)
 
        End If
 
        If ddResident.SelectedValue = 3 Then 'value of 1 or 2 = do not add, 3 = do add non-resident fee
 
            vBasicTuition = vBasicTuition + vNonResFee
        Else
            vBasicTuition = vBasicTuition
        End If
       
        Session("Tuition") = s
        Response.Redirect("estimated_cost.aspx")
 
End Sub

Open in new window

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Stephen MandersonSoftware EngineerCommented:
You need to pass the value you wish to convert from string to currency into the convert.todecimal method.

This should do you
        Dim OffCampusNotParents(4) As String
        Dim OnCampus(4) As String
        Dim OffCampusWParents(4) As String
        OffCampusNotParents(0) = 3262  '<1/2 time
        OffCampusNotParents(1) = 14644  '1/2 time
        OffCampusNotParents(2) = 15344 '3/4 time
        OffCampusNotParents(3) = 15983 'Full Time
 
        OnCampus(0) = 3262  '<1/2 time
        OnCampus(1) = 12612 '1/2 time
        OnCampus(2) = 13312 '3/4 time
        OnCampus(3) = 13951 'Full Time
 
        OffCampusWParents(0) = 3262  '<1/2 time
        OffCampusWParents(1) = 9610  '1/2 time
        OffCampusWParents(2) = 10310 '3/4 time
        OffCampusWParents(3) = 10949 'Full Time
 
        Dim StrToCurrency as Integer
        Dim vNonResFee, vClassification, vSemesters
        vClassification = ddHours.SelectedValue
        vNonResFee = 6078 ' amount to add for non-residents
 
   
        If ddHousing.SelectedValue = 1 Then '1 = OnCampus, 2 = OffCampus With Parents, 3 = OffCampus W/O Parents
 
            vBasicTuition = OnCampus(vClassification)
 
        ElseIf ddHousing.SelectedValue = 2 Then
 
            vBasicTuition = OffCampusWParents(vClassification)
        Else
            vBasicTuition = OffCampusNotParents(vClassification)
 
        End If
 
        If ddResident.SelectedValue = 3 Then 'value of 1 or 2 = do not add, 3 = do add non-resident fee
 
            vBasicTuition = vBasicTuition + vNonResFee
        Else
            vBasicTuition = vBasicTuition
        End If
 
        StrToCurrency = Convert.ToDecimal(vBasicTuition)
       
        Session("Tuition") = StrToCurrency.ToString("C0", New CultureInfo("en-US"))

Open in new window

0
 
savache27Author Commented:
Never mind, I got it to work using the following code:

Dim vBasicTuition As Integer
Dim s As String
s = String.Format("{0:c}", vBasicTuition)
Session("Tuition") = s

I didn't use your code, but what you gave me worked and helped me to figure out a way to do it. I really appreciate the help!
0
 
Stephen MandersonSoftware EngineerCommented:
Add in to your declarations

Dim vBasicTuition as String
0
 
savache27Author Commented:
Thanks again!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now