>>>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.
>
>You are absolutely correct. I commented the link of setting the SqlDbType and all works. Since I was setting the value to 0.00 it was already decimal. Thank you very much.
This is strange and I don't think it explains the problem well. It should work fine with setting type of the parameter also.
If it's not broken, fix it until it is.
My Blog