Add Data Column

Add a data column into a data table.

Create a data column with the specified column name and add it to the data table. If the data column is specified then add it directly to the specified data table.

Input

• Input : DataTable Variable The DataTable variable to add columns.

• Column Name : String Argument Optional The name of the new column.

• Data Column : Object Argument Optional The data column object to be added to the data table.

If this property is set, all properties under the Options category are ignored.

Options

• Allow Null : Specifies whether the field in the new column is allowed to be empty.

  • True - The field of the new column will be empty.

  • False - The field of the new column will not be empty.

• Auto Increment : Specifies whether the value of the column automatically increments when adding new rows.

  • True - The value of the column will be automatically incremented when adding new rows.

  • False - The value of the column will not be automatically incremented when adding new rows.

• Column Type: Specifies the type of the data column to be added to the data table. By default, the value is String.

• Default Value : Object Argument The default value for the new column when creating new rows.

It cannot set a default value on an auto increment column.

• Maximum Length : Integer Argument The maximum length of the value for the new column.

Maximum Length applies string data type only.

• Unique :

  • True - The value will be unique for each row that specifies the new column.

  • False - The value will not be unique for each row that specifies the new column.