>>Hi everybody,
>>
>>Is there a way to set InsertParameter in the code-behind?
>>
>>I'm trying to pass Control's parameter, but for some reason I'm getting this error from SP Cannot insert the value NULL into column 'PersonType'
>>
>>I'm not sure when the PersonType parameter becomes null, it may be because I try to calculate it in SP.
>>
>>How can I see it from the SP what I'm passing?
>>
>>Thanks in advance.
>
>
>You've asked the same question twice again, please don't. Post once and wait for a response..

It's a slightly different question. But I believe that InsertParameters are read-only and you can not change them in code. At least quick check yesterday in MSDN told me that.

I'll try to use SQL Profiler to see what's going on.