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 override bool IsNullable { get; set; }member this.IsNullable : bool with get, setPublic Overrides Property IsNullable As BooleanProperty Value
true if null values are accepted; otherwise, false. The default is false.
Examples
The following example creates a SqlParameter and sets some of its properties.
// using Microsoft.Data.SqlClient;
static void CreateSqlParameterNullable()
{
SqlParameter parameter = new SqlParameter("Description", SqlDbType.VarChar, 88);
parameter.IsNullable = true;
parameter.Direction = ParameterDirection.Output;
}
Remarks
Null values are handled using the DBNull class.