Setting SqlParameters to Null

[toetag]

As the title says, I'm trying to set an SqlParameter to null. Everytime my "id" = 0 I want the value to be sent as null. My guess apparently is wrong if you note the below code. With or without quotes the id = null; just doesn't work. Each time I get a message that @ID is expected by the SP and wasn't supplied.

Any Suggestions?

[b]
			SqlParameter[] parameters = 
				{
					new SqlParameter("@ID", SqlDbType.Int, 4),
					new SqlParameter("@ClientID", SqlDbType.Int, 4),
					new SqlParameter("@PersonnelID", SqlDbType.Int, 4)
				};
			if (id != 0)
			{
				parameters[0].Value = id;
			}
			else
			{
				parameters[0].Value = null;
			}
[/b]

 

[toetag]

20 seconds after I hit submit i found:

SqlInt32.Null

My apologizes for wasting the forums time.

 

[chiph]

Glad you found the answer!

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first