Large decimal value in Sql Table causes ADO.NET - overflow exception RRS feed

  • Question

  • I have a large decimal value in sql db table. When i try to read the data from the Sql Client provider, using data reader or Data Set i get a overflow exception.

    Could you tell me how to retrieve the data from SQL?

    Monday, May 27, 2013 4:40 PM


  • I suspect that you are using VS 2012 and Net 4.5.  Make sure you have the lastest updates from microsoft.  Also make sure the SQL Server has all the updates.  After that updates are installed make sure you completely rebuild you VS project.  I normally recommend deleting the project bin folder.  Updating the Net Libraries may not automatically recompile your project.


    • Proposed as answer by Mike Feng Tuesday, May 28, 2013 2:27 AM
    • Marked as answer by Mike Feng Friday, May 31, 2013 10:39 AM
    Monday, May 27, 2013 9:21 PM