SqlCeParameterCollection.CopyTo Method

Copies SqlCeParameter objects from the SqlCeParameterCollection to the specified array.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Overrides Sub CopyTo ( _
    array As Array, _
    index As Integer _
)
'Usage
Dim instance As SqlCeParameterCollection
Dim array As Array
Dim index As Integer

instance.CopyTo(array, index)

public override void CopyTo (
    Array array,
    int index
)

public:
virtual void CopyTo (
    Array^ array, 
    int index
) override

public void CopyTo (
    Array array, 
    int index
)

public override function CopyTo (
    array : Array, 
    index : int
)

Not applicable.

Parameters

• array
  The Array into which to copy the SqlCeParameter objects.

• index
  The starting index of the array.

Example

The following example copies elements of SqlCeParameterCollection to an array and clears the collection.

' ...
' create SqlCeCommand cmd
' ...
Dim myParamArray(cmd.Parameters.Count) As SqlCeParameter
cmd.Parameters.CopyTo(myParamArray, 0)
cmd.Parameters.Clear()

// ...
// create SqlCeCommand cmd
// ...
SqlCeParameter[] myParamArray = new SqlCeParameter[cmd.Parameters.Count];
cmd.Parameters.CopyTo(myParamArray, 0);
cmd.Parameters.Clear();

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeParameterCollection Class
SqlCeParameterCollection Members
System.Data.SqlServerCe Namespace