Error: Value was either too large or too small for an Int32.

I kept getting this error when trying to insert data into my SQL Server database.

The SQL Database table data type for this field phone field is numeric(18, 0)

The Store Procedure variable data type is numeric(18, 0)

And the code behind for inserting the phone number back into the database table looks like this:

sqlComm.Parameters.Add("@homePhone", SqlDbType.Int).Value = Convert.ToInt32(txtHphone.Text);

So my question is, why am I kept getting the "Error: Value was either too large or too small for an Int32." error? What and where should I change the data type to make this work?

Re: Error: Value was either too large or too small for an Int32.

Hey,

If it's numeric(18), why are you setting the parameter to Int32? It should be decimal, I believe.

Re: Error: Value was either too large or too small for an Int32.

I think this is an error while converting the textbox value to integer. What is the value in the textbox? Are you getting error for any value entered? Have you tried with values like 100 or some some number even if they may not represent valid input in the textbox?

Re: Error: Value was either too large or too small for an Int32.

First, if it's a phone number store it as a string.

Second, an int32 only ranges from +/- 2,147,483,648 which is only 10 digits...and not even all of them.

Re: Error: Value was either too large or too small for an Int32.

You are probably overflowing the Int32. It only goes up to 2,147,483,648. Unless the phone numbers start with a 1 area code you are probably going to overflow. What numbers are getting put into the textbox? You could use a long or and unsigned int

Re: Error: Value was either too large or too small for an Int32.

bmains

Hey,

If it's numeric(18), why are you setting the parameter to Int32? It should be decimal, I believe.

I changed it into decimal and this is the error I got.

Error: Failed to convert parameter from a Decimal to a Int32.

Re: Error: Value was either too large or too small for an Int32.

The number input into the textbox have this formating:

9999999999

Re: Error: Value was either too large or too small for an Int32.

That number is way to big for an int32. You should just store it as a string.(varchar)

Re: Error: Value was either too large or too small for an Int32.

So the datatype in the database table should be set to varchar(10), correct?

Re: Error: Value was either too large or too small for an Int32.

Yes, as long as the number will never be larger than 10 characters

Re: Error: Value was either too large or too small for an Int32.

You may want to define a slightly larger size. something like varchar(20). In case the number needs to be stored with extension [or, even an international number] you will need to change it again in future.

Re: Error: Value was either too large or too small for an Int32.

Thanks for all your help. I got it working now.