Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

DataColumn.AllowDBNull Property

Definition

Namespace:
System.Data
Assemblies:
netstandard.dll, System.Data.Common.dll
Assembly:
System.Data.Common.dll
Assembly:
System.Data.dll
Assembly:
netstandard.dll
Source:
DataColumn.cs
Source:
DataColumn.cs
Source:
DataColumn.cs
Source:
DataColumn.cs
Source:
DataColumn.cs

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 null values are allowed in this column for rows that belong to the table.

public:
 property bool AllowDBNull { bool get(); void set(bool value); };
public bool AllowDBNull { get; set; }
[System.Data.DataSysDescription("DataColumnAllowNullDescr")]
public bool AllowDBNull { get; set; }
member this.AllowDBNull : bool with get, set
[<System.Data.DataSysDescription("DataColumnAllowNullDescr")>]
member this.AllowDBNull : bool with get, set
Public Property AllowDBNull As Boolean

Property Value

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

Attributes

Examples

The following example creates a new DataColumn and sets its AllowDBNull property to true.

private void AddNullAllowedColumn()
{
 DataColumn column;
 column = new DataColumn("classID",
 System.Type.GetType("System.Int32"));
 column.AllowDBNull = true;

 // Add the column to a new DataTable.
 DataTable table;
 table = new DataTable();
 table.Columns.Add(column);
}

Private Sub AddNullAllowedColumn()
 Dim column As DataColumn
 column = New DataColumn("classID", _
 System.Type.GetType("System.Int32"))
 column.AllowDBNull = True

 ' Add the column to a new DataTable.
 Dim table As DataTable
 table = New DataTable
 table.Columns.Add(column)
End Sub

Applies to

See also

Feedback

Was this page helpful?