SqlParameter.IsNullable Property


Gets or sets a value that indicates whether the parameter accepts null values. IsNullable is not used to validate the parameter’s value and will not prevent sending or receiving a null value when executing a command.

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

Public Overrides Property IsNullable As Boolean

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 a SqlParameter and sets some of its properties.

Private Sub CreateSqlParameterNullable()
    Dim parameter As New SqlParameter("Description", SqlDbType.VarChar, 88)
    parameter.IsNullable = True
    parameter.Direction = ParameterDirection.Output
End Sub

.NET Framework
Available since 1.1
Return to top