IDataParameter.IsNullable Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets a value indicating whether the parameter accepts null values.

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

ReadOnly 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 an instance of the implementing class, SqlParameter, and sets some of its properties.

 Private Sub AddSqlParameter(ByVal command As SqlCommand, _
     ByVal paramValue As String)

     Dim parameter As New SqlParameter( _
         "@Description", SqlDbType.NVarChar, 16)
     parameter.Value = paramValue
     parameter.IsNullable = True
     command.Parameters.Add(parameter)
 End Sub

 Private Shared Sub SetParameterToNull(parameter As IDataParameter)
     If parameter.IsNullable Then
  parameter.Value = DBNull.Value
     Else
         Throw New ArgumentException("Parameter provided is not nullable", "parameter")
     End If
End Sub

.NET Framework
Available since 1.1
Return to top
Show: