Saturday, July 24, 2010

When I access a website there was a problem naming that Error converting data type nvarchar to numeric.?

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

When I access a website there was a problem naming that Error converting data type nvarchar to numeric.?
Be sure, it's not your web browser!


This is an error, server side, that deals with converting characters into numerics.


This can happen for the following reasons:


1. you have stored a non numerical string in a nvarchar field of your database and then want it to be converted to a numerical value; Let's say "A13" is in your database, then since there is a A in the string it is not possible for youconverter to bring it back to numeric and thus you're having this error message.


2. you have a null value stored in that field


3. you have an integer longer than the numerical value you are using. For instance you coded in the database field a Long or Very Long integer while you converter can only converts to Small Integer.


4. you have a decimal in your database and want an Integer...


No comments:

Post a Comment