value was either too large or too small for an int 32

Feb 24 2011 1:41 AM
hi,

in sql i create the table in this table i specify the datatype as an int for three fields such as phonenumber,mobilenumber and annual income.for insertion i used the stored procedure.
in .net cs page i pass the textbox value as a parameter .

cmd.Parameters.Add(

cmd.Parameters[2].Value =

when i used this the error value was either too large or too small for an int error will occur how can i solve this.


Thaks

Convert.ToInt32 (phonenmbr.Text);
"@phnmber", SqlDbType.Int);

Answers (2)