IsNullable Property

OleDbParameter.IsNullable Property

Gets or sets a value indicating whether the parameter accepts null values.

[Visual Basic]
Public Overridable Property IsNullable As Boolean  Implements _
   IDataParameter.IsNullable
[C#]
public virtual bool IsNullable {get; set;}
[C++]
public: __property virtual bool get_IsNullable();
public: __property void set_IsNullable(bool);
[JScript]
public function get IsNullable() : Boolean;
public function set IsNullable(Boolean);

Property Value

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

Implements

IDataParameter.IsNullable

Remarks

Null values are handled using the DBNull class.

Example

[Visual Basic, C#, C++] The following example creates an OleDbParameter and sets some of its properties.

[Visual Basic] 
Public Sub CreateOleDbParameter()
    Dim myParameter As New OleDbParameter("Description", OleDbType.VarChar, 88)
    myParameter.IsNullable = True
    myParameter.Direction = ParameterDirection.Output
End Sub 'CreateOleDbParameter

[C#] 
public void CreateOleDbParameter() 
 {
    OleDbParameter myParameter = new OleDbParameter("Description", OleDbType.VarChar, 88);
    myParameter.IsNullable = true;
    myParameter.Direction = ParameterDirection.Output;
 }

[C++] 
public:
void CreateOleDbParameter() 
 {
    OleDbParameter* myParameter = new OleDbParameter(S"Description", OleDbType::VarChar, 88);
    myParameter->IsNullable = true;
    myParameter->Direction = ParameterDirection::Output;
 }

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

OleDbParameter Class | OleDbParameter Members | System.Data.OleDb Namespace

Show:
© 2016 Microsoft