Why do I get an Arithmetic overflow error converting numeric to data type numeric in ADO.NET?

Question

Original Question:

Why do I get an Arithmetic overflow error converting numeric to data type numeric in ADO.NET code using the Money Data Type when amount is greater than $999,999,99?

Just as the question says... I have a bit of ADO.net code in the data access layer that talks to a Sql Server 2008 database. There is an Amount column in the table that is of data type "Money". The code works fine when inserting a record with an amount < $1,000,000 but throws this error when amount is >= $1,000,000:

"Arithmetic overflow error converting numeric to data type numeric"

I can manually run t-sql against the database updating the amount to a value larger than $1,000,000 so the database can except the amount fine... what is it about the following SqlCommand that causes the error to fire?

        MyCommand.Parameters.Add(New SqlParameter("@Amount", SqlDbType.Money))
        If IsNothing(Amount) Then
            MyCommand.Parameters("@Amount").Value = Convert.DBNull
        Else
            MyCommand.Parameters("@Amount").Value = Amount
        End If

Please give us the rest of the syntax of the command, or whatever stored procedure it's calling — MartW
– MartW, Commented Dec 16, 2009 at 16:37

Jeffrey L Whitledge · Accepted Answer · 2009-12-16 16:32:31Z

1

If an error occurs calling a stored procedure with a value, but no error occurs when directly updating the table with that same value, then that casts suspition upon the data type of the @Amount parameter. Make sure it is also defined as Money.

answered Dec 16, 2009 at 16:32

Jeffrey L Whitledge

59.7k9 gold badges76 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

codethrift Over a year ago

As you pointed out through your question... Amount was a decimal but the sql column was money. Once I converted the value before calling the Stored Procedure it worked perfect: CType(Amount, Data.SqlTypes.SqlMoney). Thanks!

Collectives™ on Stack Overflow

Why do I get an Arithmetic overflow error converting numeric to data type numeric in ADO.NET?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related