when I excute my application, , the error - 'when casting from number the value must be a number'
I am not sure if it's blowing up on this statment
retVal = (int)cmd.Parameters["@pIntErrDescOut"].Value;
"@pIntErrDescOut is a value passed from the stored procedure and its data type is int.
Also I am inserting a value into the database by setting this parameter cmd.Parameters["@PerLevel"].Value = PerLevel.Text.Trim(); --- The value data type is int in the database. How can I convert to numeric before inserting.
I am using SQL Server 2005