Insert NULL value into Stored Proc parameter datatype uniqueidentifier

[abs2003]

How can I insert NULL value into Stored Proc parameter datatype uniqueidentifier.

My stored proc

REATE PROCEDURE [bookstore_insert_WebList]
	( @ParentID 	[uniqueidentifier],
	 @MasterID 	[uniqueidentifier],
	 @ListLevel 	[int],

My code

tmpCommand.Parameters.Add(New SqlClient.SqlParameter("@ParentID", SqlDbType.UniqueIdentifier))
tmpCommand.Parameters.Add(New SqlClient.SqlParameter("@MasterID", SqlDbType.UniqueIdentifier))
.
.
.
    tmpCommand.Parameters("@ParentID").Value = vbNullString
    tmpCommand.Parameters("@MasterID").Value = vbNullString

Evidently, it can't cast 'string' into 'uniqueidentifier'

Thank you

 

[johnwm]

1. vbNullString is not a Null value, it's an empty string.
2. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_6dyq.asp

For SQL-specific questions, you will usually get a better answer in one of the specific SQL forums

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[fredericofonseca]

try

tmpCommand.Parameters("@MasterID").Value = "NULL"

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com