Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting string to numeric
Message
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
C# 2.0
Miscellaneous
Thread ID:
01544642
Message ID:
01544672
Views:
48
This message has been marked as the solution to the initial question of the thread.
>>>>>When I change to the following:
>>>>>
>>>>>param.SqlDbType = System.Data.SqlDbType.Decimal;
>>>>>param.Value = 0.00;  
>>>>>
>>>>>
>>>>>I get compiler error.
>>>>
>>>>What?
>>>
>>>What I wrote in the other message about "The explicit conversion exists (are you missing a cast?)"
>>
>>
>>That works for me:
>>
>> SqlCommand sql = new SqlCommand();
>>sql.Parameters.Add("asd");
>>sql.Parameters[0].SqlDbType = SqlDbType.Decimal;
>>sql.Parameters[0].Size = 10;
>>sql.Parameters[0].Value = 0.00;
>>sql.Parameters[0].Direction = ParameterDirection.InputOutput;
>>
>
>The above code does not produce the compilere error. But when I call the stored procedure I get error "Error converting data type numeric to numeric"

Can you post the stored procedure code?

It sounds like you are trying to cast something that is already Decimal.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform