OleDbErrorCollection Class

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v9.0.0

Source:

OleDbErrorCollection.cs

Collects all errors generated by the .NET Framework Data Provider for OLE DB. This class cannot be inherited.

public ref class OleDbErrorCollection sealed : System::Collections::ICollection

[System.ComponentModel.ListBindable(false)]
public sealed class OleDbErrorCollection : System.Collections.ICollection

[<System.ComponentModel.ListBindable(false)>]
type OleDbErrorCollection = class
    interface ICollection
    interface IEnumerable

Public NotInheritable Class OleDbErrorCollection
Implements ICollection

Inheritance

Object

OleDbErrorCollection

Attributes

ListBindableAttribute

Implements

ICollection IEnumerable

Examples

The following example displays each OleDbError within the OleDbErrorCollection collection.

public void DisplayOleDbErrorCollection(OleDbException exception)
{
   for (int i=0; i < exception.Errors.Count; i++)
   {
      MessageBox.Show("Index #" + i + "\n" +
             "Message: " + exception.Errors[i].Message + "\n" +
             "Native: " + exception.Errors[i].NativeError.ToString() + "\n" +
             "Source: " + exception.Errors[i].Source + "\n" +
             "SQL: " + exception.Errors[i].SQLState + "\n");
   }
}

Public Sub DisplayOleDbErrorCollection(exception As OleDbException)
    Dim i As Integer

    For i = 0 To exception.Errors.Count - 1
        MessageBox.Show("Index #" + i.ToString() + ControlChars.Cr _
           + "Message: " + exception.Errors(i).Message + ControlChars.Cr _
           + "Native: " + exception.Errors(i).NativeError.ToString() + ControlChars.Cr _
           + "Source: " + exception.Errors(i).Source + ControlChars.Cr _
           + "SQL: " + exception.Errors(i).SQLState + ControlChars.Cr)
    Next i
End Sub

Remarks

This class is created by OleDbException to collect instances of the OleDbError class. OleDbErrorCollection always contains at least one instance of the OleDbError class.

Properties

Count	Gets the number of errors in the collection.
Item[Int32]	Gets the error at the specified index.

Methods

CopyTo(Array, Int32)	Copies the elements of the OleDbErrorCollection into an Array, starting at the specified index within the Array.
CopyTo(OleDbError[], Int32)	Copies all the elements of the current OleDbErrorCollection to the specified OleDbErrorCollection starting at the specified destination index.
Equals(Object)	Determines whether the specified object is equal to the current object. (Inherited from Object)
GetEnumerator()	Exposes the GetEnumerator() method, which supports a simple iteration over a collection by a .NET Framework data provider.
GetHashCode()	Serves as the default hash function. (Inherited from Object)
GetType()	Gets the Type of the current instance. (Inherited from Object)
MemberwiseClone()	Creates a shallow copy of the current Object. (Inherited from Object)
ToString()	Returns a string that represents the current object. (Inherited from Object)

Explicit Interface Implementations

ICollection.IsSynchronized	For a description of this member, see IsSynchronized.
ICollection.SyncRoot	For a description of this member, see SyncRoot.

Extension Methods

See also

• Handling and throwing exceptions in .NET