>>>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.
I was trying to find an answer on today's question and I think it should help me as well
http://fredrik.nsquared2.com/viewpost.aspx?PostID=384&showfeedback=true
If it's not broken, fix it until it is.
My Blog