DataColumnCollection.RemoveAt(Int32) Method

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Source:

DataColumnCollection.cs

Removes the column at the specified index from the collection.

public:
 void RemoveAt(int index);

public void RemoveAt (int index);

member this.RemoveAt : int -> unit

Public Sub RemoveAt (index As Integer)

Parameters

index

Int32

The index of the column to remove.

Exceptions

ArgumentException

The collection does not have a column at the specified index.

Examples

The following example first uses the Contains method to determine whether a particular column is found in the collection. If it is found, the CanRemove method tests whether the column can be removed. If so, the column is removed with the RemoveAt method.

Private Sub RemoveColumnAtIndex(thisIndex As Integer)
   ' Get the DataColumnCollection from a DataTable in a DataSet.
   Dim columns As DataColumnCollection = _
       DataSet1.Tables("Orders").Columns

   If columns.CanRemove(columns(thisIndex)) Then 
      columns.RemoveAt(thisIndex)
   End If
End Sub

Remarks

If the collection is successfully changed by adding or removing columns, the CollectionChanged event occurs.

See also

• IndexOf(DataColumn)
• Contains(String)
• CanRemove(DataColumn)