Is their a way to store a null value, or a null date (If such a thing exists) into a sql server table? My data table has a date column that is specified to allow nulls. Sometimes the value

from my web form entered for the date is empty, as entered into the text box for the date. It is crashing though if I try to pass in an emptry string. So how do I pass in a null value for the date?

The code below is vb.net but I can always convert it to C# 

sprocComm.Parameters.Add(New SqlParameter("@dateOfExpire", Data.SqlDbType.DateTime))
        sprocComm.Parameters("@dateOfExpire").Value = dateToSave

Try something like this (it's C#, sorry):

sprocComm.Parameters["@dateOfExpire"].Value = String.IsNullOrEmpty(dateToSave) ? DBNull.Value : dateToSave;

I'm assuming dateToSave is a string.

If your dateToSave is DateTime then you can mark it as nullable

DateTime? dateToSave;

sprocComm.Parameters["@dateOfExpire"].Value = dateToSave == null ? DBNull.Value : dateToSave.Value;