DataColumnCollection.Add Method

System.Data Namespace DataColumnCollection Class

Adds a DataColumn to the columns collection.

1. Initializes and adds a new DataColumn to the columns collection.

[ VB ] Overloads Public Function Add ( ) As DataColumn

[ C# ] public virtual DataColumn Add ( );

[ C++ ] public: virtual DataColumn* Add ( );

[ JScript ] public function Add ( ) : DataColumn;

2. Initializes and adds a specified DataColumn object to the columns collection.

[ VB ] Overloads Public Sub Add ( DataColumn )

[ C# ] public void Add ( DataColumn );

[ C++ ] public: void Add ( DataColumn* );

[ JScript ] public function Add ( DataColumn );

3. Initializes and adds a DataColumn with the specified name to the columns collection.

[ VB ] Overloads Public Function Add ( String ) As DataColumn

[ C# ] public virtual DataColumn Add ( string );

[ C++ ] public: virtual DataColumn* Add ( String* );

[ JScript ] public function Add ( String ) : DataColumn;

4. Initializes and adds a DataColumn with the specified name and type to the columns collection.

[ VB ] Overloads Public Function Add ( String, Type ) As DataColumn

[ C# ] public virtual DataColumn Add ( string, Type );

[ C++ ] public: virtual DataColumn* Add ( String*, Type );

[ JScript ] public function Add ( String, Type ) : DataColumn;

5. Initializes and adds a DataColumn with the specified name, type, and expression to the columns collection.

[ VB ] Overloads Public Function Add ( String, Type, String ) As DataColumn

[ C# ] public virtual DataColumn Add ( string, Type, string );

[ C++ ] public: virtual DataColumn* Add ( String*, Type, String* );

[ JScript ] public function Add ( String, Type, String ) : DataColumn;

The following example initializes and adds a new DataColumn to a DataColumnCollection of a DataTable.

NOTE: This example shows how to use one of the overloaded versions of Add. For other examples that may be available, see the individual overload topics.

Private Sub AddColumn ( )
   Dim cols As DataColumnCollection
   Dim myCol As DataColumn

   ' get the DataColumnCollection of a table in a DataSet.
   cols=ds.Tables ( "Orders" ).Columns

   ' add a new column and return it.
   myCol=cols.Add ( "Total", System.Type.GetType ( "System.Decimal" ), _
      "Price + Tax" )
   myCol.ReadOnly=True
   myCol.Unique=False
End Sub

DataColumnCollection Members

Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics

DataColumnCollection.Add Method

Overload List

Example

See Also