Error calculating a text field that is formated as currency

[MJV57]

I have a form with a field cdnsale that is formated as currency but when I try to do a calculation with it it errors out as a division by zero; however if i format it as numerical i do not get this error. Can anyone help me to change my code so I can format as currency and not get this error. My current code is as follows:


decimal cdnsale;
decimal.TryParse (tRECREVHMTextBox.Text,out cdnsale);
decimal profit;
decimal grossprofpercent;

grossprofpercent = Math.Round(profit / cdnsale,2);

 

[jmeckley]

try parse will set the value to 0 if it encounters an error. this is why the function returns a boolean and uses the out modifier. the reason it's setting the number to zero is the text isn't an known number type (probably because of the currency symbol). below is the proper user of TryParse

decimal d;
var input = ATextBox.Text;
if(decimal.TryParse(input, out d)
{
   is is a valid decimal
}
else
{
   d is [b]not[/b] a valid decimal
}

you could trim the currency symbol from the text field before parsing

[COLOR=green]//assuming USD[/color]
var input = ATextBox.Text.Trim("$");

decimal d;
if(decimal.TryParse(input, out d)
{
   is is a valid decimal
}

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259