DataColumn is a true object, inheriting from the System.Object namespace
A DataColumn is exactly what it sounds like: a column of data.

The DataColumn is the foundation of a DataTable and has very similar properties to a column in a relational database table.

The data in a DataTable is represented in the same manner. So, a DataTable is made up of DataColumns and DataRows.

DataTable contains a collection of DataColumns, and this could be considered the DataTable’s schema, or structure

DataColumn Properties


True or False, default is True. Determines whether the column will allow Null values. Null values represent the absence of a value and generally require special handling


True or False, default is False. This indicates whether the DataColumn will automatically increment a counter. When this value is True, a numeric value will be placed in this column. If the column is not of a Int16, Int32, or Int64, it will be coerced to Int32. If the DataTable is to be populated by an array, a Null must be placed in the array position corresponding to the


column in the DataTable.If an expression is already present when this property is set, an exception of type ArgumentException is thrown.


Default is 1. This is the starting value of the first row in the column if the AutoIncrement property is set to True. AutoIncrementStep Default is 1. This is the value that the counter is incremented by for each new row in the DataColumn is the AutoIncrement property is True. Caption Caption for the column. If a caption is not specified, the ColumnName is returned. ColumnMapping Determines the MappingType of the column, which is used during the WriteXML method of the parent DataSet.These are the MappingTypes and their descriptions:

  • Attribute XML attribute
  • Element XML element
  • Hidden Internal structure
  • SimpleContent XmlText node


Name of the column in the DataColumnCollection. If a ColumnName is not specified before the column is added to the DataColumnCollection, the DataColumnName is set to the default (Column1, Column2, and so on).


Returns the container of the component (inherited from MarshalByValueComponent). DataType Sets, or returns, the type of data in the column. These types are members of the System.Type class. Throws an exception of type ArgumentException if data is present in the DataColumn when the DataType is set.


Determines the default value for a new row.


Returns a value indicating whether the component is in design mode (inherited from MarshalByValueComponent).


Defines an expression used to filter rows or create an aggregate column.


Returns a collection of custom user information.


Defines the maximum length of a text column.


Defines or returns the namespace of the DataColumn.


Returns the index or position of the column in the DataColumnCollection collection.

Prefix Defines or returns an XML prefix used to alias the namespace of the DataTable.


True or False, default is False. Indicates whether the column allows changes once a row has been added to the table.


Returns a reference to the parent. If Null reference or nothing, the DataColumn does not reside in a container (inherited from MarshalByValueComponent).


Returns a reference to the DataTable of which the column belongs.


True or False, default is false. Determines if the values in each row of the column must be unique.

DataColumn Methods


Releases resources used by the component (inherited from MarshalByValueComponent). Overloaded.


Returns True if two instances of the Object are equal (inherited from Object). Overloaded.


Hash function useful for hashing algorithms and data structures similar to hash tables (inherited from Object).


Returns the implementer of iServiceProvider interface (inherited from MarshalByValueComponent).


Returns the type of the current instance (inherited from Object). ToString Returns the existing column Expression. Overridden.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: