SqlParameter.IsNullable Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.
public:
virtual property bool IsNullable { bool get(); void set(bool value); };public:
property bool IsNullable { bool get(); void set(bool value); };public override bool IsNullable { get; set; }[System.ComponentModel.Browsable(false)]
[System.Data.DataSysDescription("DataParameter_IsNullable")]
public bool IsNullable { get; set; }member this.IsNullable : bool with get, set[<System.ComponentModel.Browsable(false)>]
[<System.Data.DataSysDescription("DataParameter_IsNullable")>]
member this.IsNullable : bool with get, setPublic Overrides Property IsNullable As BooleanPublic Property IsNullable As BooleanProperty Value
true if null values are accepted; otherwise, false. The default is false.
- Attributes
Examples
The following example creates a SqlParameter and sets some of its properties.
static void CreateSqlParameterNullable()
{
SqlParameter parameter = new SqlParameter("Description", SqlDbType.VarChar, 88);
parameter.IsNullable = true;
parameter.Direction = ParameterDirection.Output;
}
Private Sub CreateSqlParameterNullable()
Dim parameter As New SqlParameter("Description", SqlDbType.VarChar, 88)
parameter.IsNullable = True
parameter.Direction = ParameterDirection.Output
End Sub
Remarks
Null values are handled using the DBNull class.
Applies to
See also
Vertu í samstarfi við okkur á GitHub
Heimildina fyrir þetta efni er að finna á GitHub, þar sem þú getur líka búið til og farið yfir vandamál og sameinað beiðnir. Frekari upplýsingar er að finna í framlagshandbók okkar.
