How do I pass a null to a stored proc? This doesn't seem to work....
MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
System.DBNull.Value
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression
> How do I pass a null to a stored proc? This doesn't seem to work....
>
> MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
Cirene - 27 May 2008 01:33 GMT
Thanks Mark... as usual
> System.DBNull.Value
>
[quoted text clipped - 5 lines]
>>
>> MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
Mark Fitzpatrick - 27 May 2008 01:41 GMT
You're very welcome!
Mark
> Thanks Mark... as usual
>> System.DBNull.Value
[quoted text clipped - 6 lines]
>>>
>>> MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)