savache27
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
You need to pass the value you wish to convert from string to currency into the convert.todecimal method.
This should do you
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"))
ASKER
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!
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!
Add in to your declarations
Dim vBasicTuition as String
Dim vBasicTuition as String
ASKER
Thanks again!
Imports System.Globalization
Also I would convert.todecimal not int32 :-)