passing NULL as parameter to SP

[techgnome]

System.Data.SqlTypes.SqlString.Null the value is not important it is used to get/set the .net value type value.... you can SqlString = "sdfgsgdfg" or qlString.Value = "sdgdfgsfgsdfgf" the correct way to get a String is String = SqlString.Value

p.s. a stored procedure with invalid number of parameters passed in will fail and I'm not sure you can create a parameter object with out setting a value. However if you set the parameters default value to NULL in the sp you can omit that parameter and any other with a default value set.

You most certanly can.... I do it every day....If you create a parameter and don't set the value, and don't have a default value set, the parameter will be NULL. As long as you create it and append it, it won't (shouldn't) give you errors about missing a parameter.

Tg