>>>
>>>The original problem is because he used AddWithValue and the parameter was send as varchar. If he would use Add and exact type, this would not happen.
>>>
>>>BTW, this works
>>>
>>>SELECT CAST( 123.45 AS INT)
>>
>>Well there you go. It occurred to me last night that perhaps the original code would work if I did this:
>>
>>oCommand.Parameters.AddWithValue("@AmendmentNumber", Val(Amendments_DDL.SelectedValue))
>>
>>And sure enough it does.
>>Thanks to all.
>
>I don't recommend to use AddWithValue as I already said. AddWithValue is a quick way and it often leads to troubles. I suggest to always be explicit and use Add syntax and exact type instead. It also helps to document and requires more strict programming.
I have always used AddWithValue. What kind of problems have you seen and what commands would you replace it with? Something like this?
oCommand.Parameters.Add("@AmendmentNumber")
plus something else to set the value?