SqlErrorCollection.Count Property
.NET Framework 4.5
Gets the number of errors in the collection.
Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
The following example displays each SqlError within the SqlErrorCollection collection.
public static void ShowSqlException(string connectionString) { string queryString = "EXECUTE NonExistantStoredProcedure"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); try { command.Connection.Open(); command.ExecuteNonQuery(); } catch (SqlException ex) { DisplaySqlErrors(ex); } } } private static void DisplaySqlErrors(SqlException exception) { for (int i = 0; i < exception.Errors.Count; i++) { Console.WriteLine("Index #" + i + "\n" + "Error: " + exception.Errors[i].ToString() + "\n"); } Console.ReadLine(); }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.