I have a webpage that I have created in Visual Studio 2005/VB.net. I am trying to send values into a SQL Server Proc. In my proc, I have my input values in the PROC defined with default of NULL. How can I send a NULL from VB.net into my Proc? How can I make sure I'm sending NULL? I can't set anything to NULL in my VB code because the only valid(syntax wise) NULL is the DBNull.Value and that does not work on Strings. I end up passing spaces or something and my Proc doesn't work when I look for Null. The only way I can get it to work is to set the variable to something specific in my VB.net code and account for it in my Proc. For example, I set Age to 00 in my VB.net code as a default and send that to my Proc. In my proc I have to say if Age = '00' OR if it is a valid age I do something.

Thanks
LisaBB

When calling a stored procedure using a command object with parameters, you should be using DBNull.Value as you found. I'm not sure what error you could be getting. Even when you define a parameter with a specific DB data type, the .Value property is still of type 'Object' so you can still assign DBNull.Value to it.

-Peter