dotConnect for Dynamics 365 Documentation
Devart.Common Namespace / DbLoaderColumnCollection Class / CopyTo Method
The array into which to copy the DbLoaderColumn objects.
The zero-based index of the array.
Example

CopyTo Method (DbLoaderColumnCollection)
Copies DbLoaderColumn objects from the DbLoaderColumnCollection to the specified array.
Syntax
'Declaration
 
Public Sub CopyTo( _
   ByVal array() As DbLoaderColumn, _
   ByVal index As Integer _
) 
 

Parameters

array
The array into which to copy the DbLoaderColumn objects.
index
The zero-based index of the array.
Example
The following example exports the DbLoaderColumnCollection to an array of Devart.Data.SqlShimLoaderColumn 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 SqlShimLoaderColumnCollection myColumns
  // ...
  SqlShimLoaderColumn[] myColumnArray = new SqlShimLoaderColumn[(2*myColumns.Count) - 1];
  myColumns.CopyTo(myColumnArray, 0);
  myColumns.CopyTo(myColumnArray, myColumns.Count);
  myColumns.Clear();
  return true;
}
Public Function DoubleYourColumns() As Boolean
  ' ...
  ' create SqlShimLoaderColumnCollection myColumns
  ' ...
  Dim myColumnArray(2 * myColumns.Count - 1) As SqlShimLoaderColumn
  myColumns.CopyTo(myColumnArray, 0)
  myColumns.CopyTo(myColumnArray, myColumns.Count)
  myColumns.Clear()
  Return True
End Function 'DoubleYourColumns
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also