DataColumn.AllowDBNull Property

Definition

Gets or sets a value that indicates whether null values are allowed in this column for rows that belong to the table.

C#
public bool AllowDBNull { get; set; }
C#
[System.Data.DataSysDescription("DataColumnAllowNullDescr")]
public bool AllowDBNull { get; set; }

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.

C#
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);
}

Applies to

Product Versions
.NET Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9
.NET Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard 2.0, 2.1

See also