SqlCeErrorCollection.CopyTo Method
Copies the elements of the SqlCeErrorCollection into an Array, starting at the given index within the Array.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Syntax
'Declaration
Public Sub CopyTo ( _
array As Array, _
index As Integer _
)
'Usage
Dim instance As SqlCeErrorCollection
Dim array As Array
Dim index As Integer
instance.CopyTo(array, index)
public void CopyTo(
Array array,
int index
)
public:
virtual void CopyTo(
Array^ array,
int index
) sealed
abstract CopyTo :
array:Array *
index:int -> unit
override CopyTo :
array:Array *
index:int -> unit
public final function CopyTo(
array : Array,
index : int
)
Parameters
- array
Type: System.Array
The Array into which to copy the elements.
- index
Type: System.Int32
The starting index of the array.
Implements
ICollection.CopyTo(Array, Int32)
Exceptions
| Exception | Condition |
|---|---|
| ArgumentException | The sum of index and the number of elements in the SqlCeErrorCollection is greater than the Length of the Array. |
| ArgumentNullException | The array is nulla null reference (Nothing in Visual Basic). |
| ArgumentOutOfRangeException | The index is not valid for the array. |
Examples
The following example displays each SqlCeError within the SqlCeErrorCollection collection.
Public Sub DisplaySqlCeErrors(ByVal errorCollection As SqlCeErrorCollection)
Dim err As SqlCeError
Dim bld As New StringBuilder()
For Each err In errorCollection
bld.Append((ControlChars.Cr & " Error Code: " & err.HResult.ToString("X")))
bld.Append((ControlChars.Cr & " Message : " & err.Message))
bld.Append((ControlChars.Cr & " Minor Err.: " & err.NativeError))
bld.Append((ControlChars.Cr & " Source : " & err.Source))
Dim numPar As Integer
For Each numPar In err.NumericErrorParameters
If 0 <> numPar Then
bld.Append((ControlChars.Cr & " Num. Par. : " & numPar))
End If
Next numPar
Dim errPar As String
For Each errPar In err.ErrorParameters
If [String].Empty <> errPar Then
bld.Append((ControlChars.Cr & " Err. Par. : " & errPar))
End If
Next errPar
MessageBox.Show(bld.ToString())
bld.Remove(0, bld.Length)
Next err
End Sub 'DisplaySqlCeErrors
public void DisplaySqlCeErrors(SqlCeErrorCollection errorCollection ) {
StringBuilder bld = new StringBuilder();
foreach (SqlCeError err in errorCollection) {
bld.Append("\n Error Code: " + err.HResult.ToString("X"));
bld.Append("\n Message : " + err.Message);
bld.Append("\n Minor Err.: " + err.NativeError);
bld.Append("\n Source : " + err.Source);
foreach (int numPar in err.NumericErrorParameters) {
if (0 != numPar) bld.Append("\n Num. Par. : " + numPar);
}
foreach (string errPar in err.ErrorParameters) {
if (String.Empty != errPar) bld.Append("\n Err. Par. : " + errPar);
}
MessageBox.Show(bld.ToString());
bld.Remove(0, bld.Length);
}
}