ColumnName Property

DataColumn.ColumnName Property


Gets or sets the name of the column in the DataColumnCollection.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public string ColumnName { get; set; }

Property Value

Type: System.String

The name of the column.

Exception Condition

The property is set to null or an empty string and the column belongs to a collection.


A column with the same name already exists in the collection. The name comparison is not case sensitive.

When a DataColumn is created, it has no ColumnName value. However, when the DataColumn is added to a DataColumnCollection for a DataTable object, it is given a default name ("Column1", "Column2", and so on).

By default, the Caption value is set to the ColumnName value.

The following examples gets the ColumnName for every column in every table in a DataSet. The example also shows how to create a DataColumn with a new ColumnName.

private void PrintColumnNames(DataSet dataSet)
    // For each DataTable, print the ColumnName.
    foreach(DataTable table in dataSet.Tables)
        foreach(DataColumn column in table.Columns)

private void AddColumn(DataTable table)
    DataColumn column;
    column = new DataColumn();
    column.ColumnName = "SupplierID";
    column.DataType = System.Type.GetType("System.String");
    column.Unique = true;
    column.AutoIncrement = false;
    column.Caption = "SupplierID";
    column.ReadOnly = false;

    // Add the column to the table's columns collection.

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft