http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/Number conversion and decimal accuracyhttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/en-usThu, 21 May 2009 15:11:31 GMTThu, 21 May 2009 15:11:31 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<p>Damn accountants ........ but will keep your tip in mind, thx :)</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=470044Thu, 21 May 2009 15:11:31 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4700440http://channel9.msdn.com/470044/WebViewBug.aspx?EVT=0Damn accountants ........ but will keep your tip in mind, thx :)&#193;rni Gunnar Ragnarsson0http://channel9.msdn.com/470044/Trackback.aspx<p>The only possible catch is that rounding in C# decimal type might not match the rounding used in the database if you have any rounding in your stored procedures.&nbsp; By default C# decimal.Round() uses&nbsp;rounding to even by default&nbsp;while I beleive SQL Server uses 'away from zero' rounding.&nbsp;We always use decimal.round(value, MidpointRounding.AwayFromZero) to ensure that they match.</p> <p>&nbsp;Turns out Accountants seem to get quite annoyed when rounding errors put values out by a penny ...</p> <p>Herbie</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=470038Thu, 21 May 2009 13:28:45 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4700380http://channel9.msdn.com/470038/WebViewBug.aspx?EVT=0The only possible catch is that rounding in C# decimal type might not match the rounding used in the database if you have any rounding in your stored procedures.&nbsp; By default C# decimal.Round() uses&nbsp;rounding to even by default&nbsp;while I beleive SQL Server uses 'away from zero'&#8230;Herbie Smith0http://channel9.msdn.com/470038/Trackback.aspx<p>And that totally did the trick .... I have never had to think about this in my applications up until now .... clearly need to read up on datatypes :)</p> <p>Thx guys ...</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=470027Thu, 21 May 2009 11:44:51 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4700270http://channel9.msdn.com/470027/WebViewBug.aspx?EVT=0And that totally did the trick .... I have never had to think about this in my applications up until now .... clearly need to read up on datatypes :) Thx guys ...&#193;rni Gunnar Ragnarsson0http://channel9.msdn.com/470027/Trackback.aspx<p>Stevo's right. That would change a lot. Decimal is exactly made for numbers where the accuracy is important.</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=469938Wed, 20 May 2009 17:38:35 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4699380http://channel9.msdn.com/469938/WebViewBug.aspx?EVT=0Stevo's right. That would change a lot. Decimal is exactly made for numbers where the accuracy is important.Tommy Carlier0http://channel9.msdn.com/469938/Trackback.aspx<p>Would that change things ?</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=469931Wed, 20 May 2009 17:22:55 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4699310http://channel9.msdn.com/469931/WebViewBug.aspx?EVT=0Would that change things ?&#193;rni Gunnar Ragnarsson0http://channel9.msdn.com/469931/Trackback.aspx<p>Firstly why aren't your using a decimal type in c#?</p>http://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=469928Wed, 20 May 2009 17:06:17 GMThttp://channel9.msdn.com/forums/TechOff/469915-Number-conversion-and-decimal-accuracy/?CommentID=4699280http://channel9.msdn.com/469928/WebViewBug.aspx?EVT=0Firstly why aren't your using a decimal type in c#?stevo_0http://channel9.msdn.com/469928/Trackback.aspx