locked
SQL Server Money and .NET Data Type RRS feed

  • Question

  • User-950908124 posted
    I'm hoping this is the right forum. Retrieving a Money data-type from SQL Server converts to Double in .NET. But there are rounding problems, I only want 2 decimal points and sometimes rounding will round up the nearest whole integer value. What is the best data type to use for Money where accuracy is critical (financial-number-crunching)? Thanks, Shawn
    Wednesday, April 14, 2004 12:40 PM

All replies

  • User-37741689 posted
    Use the .NET Currency type and not double.
    Sunday, April 18, 2004 11:23 PM
  • User2032526919 posted
    System.Decimal
    Monday, April 19, 2004 12:38 AM