SqlErrorCollection Class
Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
Assembly: System.Data (in System.Data.dll)
| Name | Description | |
|---|---|---|
![]() | Count | Gets the number of errors in the collection. |
![]() | Item(Int32) | Gets the error at the specified index. |
| Name | Description | |
|---|---|---|
![]() | CopyTo(Array, Int32) | Copies the elements of the SqlErrorCollection collection into an Array, starting at the specified index. |
![]() | CopyTo(SqlError(), Int32) | Copies the elements of the SqlErrorCollection collection into a SqlErrorCollection, starting at the specified index. |
![]() | Equals(Object) | Determines whether the specified object is equal to the current object.(Inherited from Object.) |
![]() | GetEnumerator() | Returns an enumerator that iterates through the SqlErrorCollection. |
![]() | GetHashCode() | Serves as the default hash function. (Inherited from Object.) |
![]() | GetType() | |
![]() | ToString() | Returns a string that represents the current object.(Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | ICollection.IsSynchronized | For a description of this member, see IsSynchronized. |
![]() ![]() | ICollection.SyncRoot | For a description of this member, see SyncRoot. |
| Name | Description | |
|---|---|---|
![]() | AsParallel() | Overloaded. Enables parallelization of a query.(Defined by ParallelEnumerable.) |
![]() | AsQueryable() | Overloaded. Converts an IEnumerable to an IQueryable.(Defined by Queryable.) |
![]() | Cast(Of TResult)() | Casts the elements of an IEnumerable to the specified type.(Defined by Enumerable.) |
![]() | OfType(Of TResult)() | Filters the elements of an IEnumerable based on a specified type.(Defined by Enumerable.) |
This class is created by SqlException to collect instances of the SqlError class. SqlErrorCollection always contains at least one instance of the SqlError class.
The following example displays each SqlError within the SqlErrorCollection collection.
Public Sub ShowSqlException(ByVal connectionString As String) Dim queryString As String = "EXECUTE NonExistantStoredProcedure" Using connection As New SqlConnection(connectionString) Dim command As New SqlCommand(queryString, connection) Try command.Connection.Open() command.ExecuteNonQuery() Catch ex As SqlException DisplaySqlErrors(ex) End Try End Using End Sub Private Sub DisplaySqlErrors(ByVal exception As SqlException) Dim i As Integer For i = 0 To exception.Errors.Count - 1 Console.WriteLine("Index #" & i & ControlChars.NewLine & _ "Error: " & exception.Errors(i).ToString() & ControlChars.NewLine) Next i Console.ReadLine() End Sub
Available since 1.1
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



