Calling A Stored Procedure With Null Parameters And Sqldataadapter

I have a stored procedure which I cann from my C# code. I am passing some parameters which I put in a HashTable first. It looks like that: paramname1 value1 paramname2 value2

Solution 1:

I think you have to check if its null and set it to DBNull.Value instead of null otherwise it thinks that the parameter is missing as it has a null value.