I don't really understand why this happens just with Euro, but fact is when I use string.ToDecimal() and my Cultures are formatted for a European country, then it's not converting correctly in manner of:
expected value: 1.534,40
received value: 153440.00
its a small difference, at least to me :-)
The CurrentUICulture contains an NumberFormat which we can append to convert:
System.Globalization.NumberFormatInfo nfUs = Thread.CurrentThread.CurrentUICulture.NumberFormat;
Place attention that first i use "System.Globalization.InvariantCulture" and just on the ToString i apply "c" and my needed culture.
string formattedNumber = Convert.ToDecimal(string.Concat(formating,".",formatingCents), System.Globalization.InvariantCulture).ToString("c", nfUs);
Am I the only one who faced off with this problem?
Sunday, May 28, 2006
How-To: Convert Euro correctly ... [string.ToDecimal()]
at 6:13 AM 0 comments Posted by roni schuetz
Labels: .net
Friday, May 26, 2006
How-To: Split web.config sections into different files.
with my spin of automation I figured out that in our Build-Process we have to change some settings depends on the environment [development, testing, staging, life (we get there soon :-) )].
While each environment has its own connection strings and app-settings section we decided to split them from the web.config file and put them into different files. Well i didn't thought that this is possible, but MS have thought about it :-) Thanks!
<connectionStrings configSource="YourFileName1.xml"/>
<appSettings configSource="YourFileName2.xml"/>
Note: it has to be an XML file, correct me if I'm wrong but with anything else it worked.
great we have now own files which we can just copy after the deployment but ... here comes the clue behind it, if you do that you should also do the following thing to protect your files:
<location path="YourFileName1.xml">
<system.web>
<authorization>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="YourFileName2.xml">
<system.web>
<authorization>
<deny users="*"/>
</authorization>
</system.web>
</location>
without to do that everybody else access your file's and can potentially harm your application - keep attention about it.
at 12:40 AM 1 comments Posted by roni schuetz
Labels: .net
Tuesday, May 23, 2006
Thanks. No.
Thanks. No.: "You�re not a bad person, and no one hates you, but it would be valuable to learn the very personal preferences of your friends, family members, and co-workers before including them in unrequested email or choosing to expose their private address to people they don�t know."
at 10:39 PM 0 comments Posted by roni schuetz
ever needed to delete records based on the length?
how-to:
Delete FROM TableName where LEN(RTRIM(LTRIM( COL-Name ))) > 3
at 10:06 PM 0 comments Posted by roni schuetz
Sunday, May 21, 2006
WebserviceX.NET :: XML Web Services solution provider
useful webservices:
WebserviceX.NET :: XML Web Services solution provider: "Web services enable to quickly integrate applications across multiple platforms, systems and even across businesses. Emerging web services standards such as SOAP, WSDL and UDDI will enable system-to-system communication that is easier and cheaper than ever before.
WebserviceX.NET provides programmable business logic components and standing data that serve as 'black boxes ' to provide access to functionality and data via web services"
at 1:16 PM 0 comments Posted by roni schuetz
Labels: .net