User2003259384 posted
I find the following workarround, I'm not sure that is one easy , but is working
1) I changed in all tables and procedure where there is
Price money
to
Price decimal (18,2)
(could be used something else)
Basically I changed in ads table and in procedures: GetAllAdsByQuery, InsertAd, RelistAd
UpdateAd (check in db if there is necessary in others , but looks that is in my case)
2) changed in files where money is used to be decimal(18,2)
changed also in files
currency ---> to decimal , allover where is used
3) where there is in format like
String.Format("{0:c}", ad.Price);
to something like
AdPriceLabel.Text = String.Format("EUR {0:0.00}", ad.Price);
here {0:c} --> c is for currency
but as I changed to EUR , it is 0:0.00
in "EUR {0:0.00}" ---> EUR is just a string
This is working , but sure there is no real conversion , it is
only displayed in EUR , you need to enter all Ads with prices in EUR from start
You can make similar for £
Observation
It is possible to work just making step 3) only