IsNullable Property

IDataParameter.IsNullable Property

 

Gets a value indicating whether the parameter accepts null values.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

bool IsNullable { get; }

Property Value

Type: System.Boolean

true if null values are accepted; otherwise, false. The default is false.

Null values are handled using the DBNull class.

The following example creates an instance of the implementing class, SqlParameter, and sets some of its properties.

    private static void AddSqlParameter(SqlCommand command, 
        string paramValue)
    {
        SqlParameter parameter = new SqlParameter(
            "@Description", SqlDbType.VarChar);
        parameter.Value = paramValue;
        parameter.IsNullable = true;
        command.Parameters.Add(parameter);
    }

private static void SetParameterToNull(IDataParameter parameter)
{
    if (parameter.IsNullable)
    {
        parameter.Value = DBNull.Value;
    }
    else
    {
        throw new ArgumentException("Parameter provided is not nullable", "parameter");
    }
}

.NET Framework
Available since 1.1
Return to top
Show:
© 2016 Microsoft