tags:

views:

19

answers:

2
Q: 

How to pass null for a parameter in stored procedure - the parameter is uniqueidentifier

In C# code I have a variable Guid? name.But,how to initialize this parameter to null,since I cannot assign null for a guid type

A:  
param = New SqlParameter("@GUID_ID", SqlDbType.UniqueIdentifier, 16)
param.Value = DBNull.Value
Mitch Wheat  2010-03-22 07:19:35
A: 

Set the parameter value to DBNull.Value.

 2010-03-22 07:19:53
That does not work for Guid? name
jess  2010-03-22 07:51:12

related questions

How to check if an object is nullable?
how do I pass null to int column in linq
MySQL Composite PK with Nullable FKs
c# why cant a nullable int be assigned null as a value
Can XmlSerializer deserialize into a Nullable<int>?
Nullable<T>: and overloaded operators, bool? & bool
Nullable type issue with ?: Conditional Operator
Using nullable types in C#
History of VB.NET Nullable syntax
In C# why can't a conditional operator implicitly cast to a nullable type
C# ADO.NET: nulls and DbNull -- is there more efficient syntax?
Nullable GUID
Initialising a struct variable to Nullable<int>
Why is this code invalid in C#?
.NET Dynamic Objects with Reflection
How do I use DateTime.TryParse with a Nullable<DateTime>?
Get null == null in SQL
C# nullable string error
Proper nullable type checking in C#?
What's the difference between 'int?' and 'int' in C#?
What does "DateTime?" mean in C#?
Conditional operator assignment with Nullable<value> types?
Windows Forms Designer upset by a control with a nullable property
C#: Is there any difference between bool? and Nullable<bool> ?
How to parse a string into a nullable int in C# (.NET 3.5)