Unformatting formatted strings?

[SamIAm]

I am displaying money values in a textbox like this:
txtCountryPack. Text = String.Format(" {0:c}", dr[0]["Pack"]);

I then need to updated my Database:
decimal packPrice = Convert.ToDecim al(txtCountryPa ck.Text.Trim()) ;

The problem is that the value is in a formatted format i.e. $300.00
How do I remove the formatting with have to do a SubString?

Cheers.

S

[Jay B. Harlow [MVP - Outlook]]

SamIAm,
Consider using Decimal.Parse directly instead, Convert.ToDecim al indirectly
calls Decimal.Parse.

There is an overloaded version that accepts the Globalization.N umberStyles
enum.

There is a NumberStyles.Cu rrency value, which will parse out the numeric
dollar amount.

decimal packPrice = Decimal.Parse(t xtCountryPack.T ext.Trim(),
NumberStyles.Cu rrency);

The other option is to use the overloaded Convert.ToDecim al that accepts a
format provider, if there is a format provider that is a Currency amount.

Hope this helps
Jay

"SamIAm" <sa****@rubbach icken.com> wrote in message
news:OU******** *****@TK2MSFTNG P12.phx.gbl...

I am displaying money values in a textbox like this:
txtCountryPack. Text = String.Format(" {0:c}", dr[0]["Pack"]);

I then need to updated my Database:
decimal packPrice = Convert.ToDecim al(txtCountryPa ck.Text.Trim()) ;

The problem is that the value is in a formatted format i.e. $300.00
How do I remove the formatting with have to do a SubString?

Cheers.

S

[SamIAm]

Thanks - works like a charm

S
"Jay B. Harlow [MVP - Outlook]" <Ja********@ema il.msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

SamIAm,
Consider using Decimal.Parse directly instead, Convert.ToDecim al indirectly calls Decimal.Parse.

There is an overloaded version that accepts the Globalization.N umberStyles
enum.

There is a NumberStyles.Cu rrency value, which will parse out the numeric
dollar amount.

decimal packPrice = Decimal.Parse(t xtCountryPack.T ext.Trim(),
NumberStyles.Cu rrency);

The other option is to use the overloaded Convert.ToDecim al that accepts a
format provider, if there is a format provider that is a Currency amount.

Hope this helps
Jay

"SamIAm" <sa****@rubbach icken.com> wrote in message
news:OU******** *****@TK2MSFTNG P12.phx.gbl...

I am displaying money values in a textbox like this:
txtCountryPack. Text = String.Format(" {0:c}", dr[0]["Pack"]);

I then need to updated my Database:
decimal packPrice = Convert.ToDecim al(txtCountryPa ck.Text.Trim()) ;

The problem is that the value is in a formatted format i.e. $300.00
How do I remove the formatting with have to do a SubString?

Cheers.

S