Export (0) Print
Expand All

DataColumn.DataColumn(String, Type, String) Constructor

Initializes a new instance of the DataColumn class using the specified name, data type, and expression.

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

public DataColumn (
	string columnName,
	Type dataType,
	string expr
)
public DataColumn (
	String columnName, 
	Type dataType, 
	String expr
)
public function DataColumn (
	columnName : String, 
	dataType : Type, 
	expr : String
)
Not applicable.

Parameters

columnName

A string that represents the name of the column to be created. If set to a null reference (Nothing in Visual Basic) or an empty string (""), a default name will be specified when added to the columns collection.

dataType

A supported DataType.

expr

The expression used to create this column. For more information, see the Expression property.

Exception typeCondition

ArgumentNullException

No dataType was specified.

The following example creates a computed column.

private void AddDataColumn(DataTable table)
{
    System.Type decimalType;
    decimalType = System.Type.GetType("System.Decimal");

    // Create the column. The name is 'Tax,' with data type Decimal,and 
    // an expression ('UnitPrice * .0862) to calculate the tax.
    DataColumn column = new DataColumn("Tax", 
        decimalType, "UnitPrice * .0862");

    // Set various properties.
    column.AutoIncrement = false;
    column.ReadOnly = true;

    // Add to Columns collection.;
    table.Columns.Add(column);
}

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

XNA Framework

Supported in: 1.0

Community Additions

ADD
Show:
© 2014 Microsoft