CopyTo Method (DbLoaderColumnCollection)

In This Topic

Syntax
Example
Requirements
See Also

Copies DbLoaderColumn objects from the DbLoaderColumnCollection to the specified array.

Syntax

Visual Basic
C#

public void CopyTo( 
   DbLoaderColumn[] array,
   int index
)

'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.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.

csharp

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;
}

Visual Basic

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

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

Reference

DbLoaderColumnCollection Class
DbLoaderColumnCollection Members

Send Feedback