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

Calculate sum of currency textbox values

Hi Experts,

I need help on what is probably a very basic question for someone that knows what they are doing.

Windows Application, VB.net 2005, SQL Server 2005.

TextBoxA = Currency value
TextBoxB = Currency value
TextBoxC = Currency Value
TextBoxD = Currency Value
(Values can be Null)

TextBoxE = Sum of the values above

Thanks in advance for your help.

Dave

0
dave_sky
Asked:
dave_sky
  • 4
  • 3
1 Solution
 
iHadiCommented:
Hi

The following code does exactly what you explained (according to how I understood it):

        Dim a(4) As Decimal
        Dim Result As Decimal
        a(0) = System.Convert.ToDecimal(Val(TextBoxA.Text))
        a(1) = System.Convert.ToDecimal(Val(TextBoxB.Text))
        a(2) = System.Convert.ToDecimal(Val(TextBoxC.Text))
        a(3) = System.Convert.ToDecimal(Val(TextBoxD.Text))

        Result = a(0) + a(1) + a(2) + a(3)
        TextBoxE.Text = Result.ToString
0
 
dave_skyAuthor Commented:
Hi,

Thanks for the response.
I used the code on a buttonClick event...
Tried the from load...
 
I can't get the code to work, maybe I wasn't clear on my post.

Using the ButtonClick event, TextBoxes A,B,C,&D show their individual values in TextBoxE but the sum of the TextBoxes are not calculated.

0
 
iHadiCommented:
Can you describe whats the output of the button event more, like give me an example of whats happening and the correct values you want
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
dave_skyAuthor Commented:
HI,

Let's try this:

All TextBox Null values are $0.00
Properties are set to Currency.

I enter these amounts:
TextBoxA = $10.00
TextBoxB = $10.00
TextBoxC = $10.00
TextBoxD = $0.00

After buttonClick event:
TextBoxE changes from $0.00 to 0 (Should be = $30.00)

I hope this helps.




0
 
pradeepsudharsanCommented:
       TextBoxE.Text = (decimal.Parse(TextBoxA.Text)+decimal.Parse(TextBoxB.Text)+decimal.Parse(TextBoxC.Text)+decimal.Parse(TextBoxD.Text)).ToString


0
 
iHadiCommented:
       Dim a(4) As Decimal
        Dim Result As Decimal
        a(0) = System.Convert.ToDecimal(Val(TextBoxA.Text.Replace("$", "")))
        a(1) = System.Convert.ToDecimal(Val(TextBoxB.Text.Replace("$", "")))
        a(2) = System.Convert.ToDecimal(Val(TextBoxC.Text.Replace("$", "")))
        a(3) = System.Convert.ToDecimal(Val(TextBoxD.Text.Replace("$", "")))

        Result = a(0) + a(1) + a(2) + a(3)
        TextBoxE.Text = Format(Result, "$0.00")
0
 
dave_skyAuthor Commented:

iHadi, the code worked great! thank you very much.

pradeepsudharsan, i'm sorry but I got an error message with your code:
"The input string was not in the correct format."

0
 
dave_skyAuthor Commented:
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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