Failed to convert parameter value from a String to a Decimal

[sweatha]

Hi

In sql server 2005 I have a column as

GraduationYear Decimal(4,0). In asp.net I used the coding for that as

SqlParameter GraduationYear = new SqlParameter("@GraduationYear", SqlDbType.Decimal);
GraduationYear.Value = GYTextBox.Text;

but while running I got error as

Failed to convert parameter value from a String to a Decimal.

[Curtis Rutland]

Obviously there is a conversion error. Try
GraduationYear.Value = Convert.ToDecimal(GYTextBox.Text);

[sweatha]

Obviously there is a conversion error. Try
GraduationYear.Value = Convert.ToDecimal(GYTextBox.Text);

Hi

I tried that but it is still showing error:

Input string was not in a correct format.

[arunbojan]

Hi ,

Your error may be because you have not specified the size of the datatype decimal(4,0)..... Try passing the size with the parameters u have given..

ie,
SqlParameter GraduationYear = new SqlParameter("@GraduationYear", SqlDbType.Decimal,(4,0));


Arun

[nmsreddi]

Hello

the error what you get is a compile time or run time error ,

most of the you will get "Input string not in a correct " error if the input is null or empty just check the text box value what you are passing is correct or not.