CopyTo Method (DbLoaderColumnCollection)
The following example exports the
DbLoaderColumnCollection to an array of
Devart.Data.SqlServer.SqlLoaderColumn objects, doubles the size of the array by using
CopyTo and returns the collection. It then clears the collection, and returns
true if the columns are no longer persisting. This example assumes that a
DbLoaderColumnCollection has already been created.
public bool DoubleYourColumns() {
// ...
// create SqlLoaderColumnCollection myColumns
// ...
SqlLoaderColumn[] myColumnArray = new SqlLoaderColumn[(2*myColumns.Count) - 1];
myColumns.CopyTo(myColumnArray, 0);
myColumns.CopyTo(myColumnArray, myColumns.Count);
myColumns.Clear();
return true;
}
Public Function DoubleYourColumns() As Boolean
' ...
' create SqlLoaderColumnCollection myColumns
' ...
Dim myColumnArray(2 * myColumns.Count - 1) As SqlLoaderColumn
myColumns.CopyTo(myColumnArray, 0)
myColumns.CopyTo(myColumnArray, myColumns.Count)
myColumns.Clear()
Return True
End Function 'DoubleYourColumns