Hi friends,

I need help with the below problem.  Currently through our old classic asp the "spanish" users are storing the data in the US currency format and while rendering the data will be displayed in US format, but just replacing the symbol $ with €. This is just symbol replacement. Nothing much. Now we are migrating to asp.net (frameworks ==> .net 3.5 framework and asp.net 2.0 framework), where i have to display this US format data in french for the French users. The culture is "fr-FR". Since i am running under French culture ("fr-FR") Thread i am uanble to convert the data coming in US format as a string to decimal format , becuase as i said above the currency is stored in USA format. See sample code below. where "currencyFromDatabase" is the data pulled from database (in US format) 

            Thread.CurrentThread.CurrentCulture=new CultureInfo("fr-FR");
            decimal d = 0.00m;
            double dbl = 0.00;

            string currencyFromDatabase = "23.23";

           //currencyData = currencyData + "M";

How can i do this? Could somebody help me on this.? An early reply is highly appreciated.

          

Hi,

To convert US currency to French you should use web service. There are everal web services available for currency conversion.

Please refer below link for more information on currency format-

http://msdn.microsoft.com/en-us/goglobal/bb688110.aspx

Thanks Leena,

I am looking in to it right now. I posted my problem in the below post of asp.net forums. If possible and you encountered something similar could you reply to that post?

http://forums.asp.net/t/1478031.aspx 

Thank You

TAK