Define an SQL datetime Parameter as nullable

146 Views Asked by At

In my stored procedure I am trying to define this datetime parameter as a nullable variable.

@StartDate datetime = null

When I try and dynamically retrieve the parameters in code.

SqlCommandBuilder.DeriveParameters(sqlCommand);

int parameterId = 1;
foreach (SqlParameter parameter in sqlCommand.Parameters)
{
    parameters.Add(new DynamicParamaters()
    {
        ParameterId = parameterId,
        DisplayName = parameter.ParameterName.Substring(1),
        ParameterName = parameter.ParameterName,
        DataType = GetDataType(parameter.ParameterName, parameter.DbType.ToString(), parameter.SqlDbType.ToString()),
        IsNullable = parameter.IsNullable,
        Value = parameter.Value
    });
}

The parameter value IsNullable gets set to false.

How do I define my datetime variable as nullable variable so that SqlCommandBuilder.DeriveParameters() can recognize it as a nullable parameter?

0

There are 0 best solutions below