Convert formatted string to string?

[rockdale]

Hi, All

I have a datagrid with TemplateColumn as following. Notice the "{0:c}"
format the price as $8.90 for 8.90 and ($7.8) for -7.8

<ItemTemplate>
<asp:Label id=lblPrice runat="server" Text='<%#
DataBinder.Eval(Container, "DataItem.price","{0:c}") %>'>
</asp:Label>
</ItemTemplate>

on the backend C# code:

I need to get the price and do some calculation

decimal decPrice =
decimal.Parse(lblPrice.Text,System.Globalization.N umberStyles.AllowCurrencySymbol);

It does not work.

How should I do to get the original numeric without the formatting?

Thanks a lot

[Erik Funkenbusch]

On 11 Apr 2006 13:02:31 -0700, rockdale wrote:

I need to get the price and do some calculation

decimal decPrice =
decimal.Parse(lblPrice.Text,System.Globalization.N umberStyles.AllowCurrencySymbol);

It does not work.

While you can make this solution work, wouldn't it be much easier just to
use the data from the dataset?

[Kevin Spencer]

Strip out the '$' character first.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

"rockdale" <ro************@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...

Hi, All

I have a datagrid with TemplateColumn as following. Notice the "{0:c}"
format the price as $8.90 for 8.90 and ($7.8) for -7.8

<ItemTemplate>
<asp:Label id=lblPrice runat="server" Text='<%#
DataBinder.Eval(Container, "DataItem.price","{0:c}") %>'>
</asp:Label>
</ItemTemplate>

on the backend C# code:

I need to get the price and do some calculation

decimal decPrice =
decimal.Parse(lblPrice.Text,System.Globalization.N umberStyles.AllowCurrencySymbol);

It does not work.

How should I do to get the original numeric without the formatting?

Thanks a lot

[rockdale]

Thanks for the replies.
I am using datatable but DataSet

private void RegisteredTapeDetailDataBinding(int pStoreKey, int
pFiscalKey)
{
SqlStorage ss = new SqlStorage();
dgridResult.DataSource = ss.GetPriceDataTable(pStoreKey).DefaultView;
dgridResult.DataBind();
}

I do not think I can use the data in a datatable, am I right?
Thanks