How to know actual problem because of which SqlException is thrown?

by

Try something like this, this will help you in handling different conditions.

use a try catch block like this: 

try    
{
  ...
  ...
}
catch (SqlException ex)
{
  switch (ex.Number) 
    { 
        case 4060: // Invalid Database 
                  ....
                  break;

        case 18456: // Login Failed 

                  ....

                  break;

        case 547: // ForeignKey Violation 

                  ....

                  break;

        case 2627: 
                // Unique Index/ Primary key Violation/ Constriant Violation 

                  ....

                  break;

        case 2601: // Unique Index/Constriant Violation 

                  ....

                  break;

        default: 

                  ....

                  break;    

       } 
}

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. ADO.NET |DataDirectory| where is this documented?
  3. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  4. Get the generated SQL statement from a SqlCommand object?
  5. Get connection string from App.config
  6. Can you get the column names from a SqlDataReader?
  7. Is it necessary to manually close and dispose of SqlDataReader?
  8. How to catch a specific SqlException error?
  9. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  10. How to create a DataTable in C# and how to add rows?
  11. Handling ExecuteScalar() when no results are returned
  12. Calling Oracle stored procedure from C#?
  13. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  14. ado.net Closing Connection when using “using” statement
  15. How to run multiple SQL commands in a single SQL connection?
  16. How to pass a table-value parameter
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. Fill an array (or arraylist) from SqlDataReader
  19. DataTable equivalent in Java [duplicate]
  20. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. How do I create a DataTable, then add rows to it?
  23. Add WHERE clauses to SQL dynamically / programmatically
  24. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  25. Why does the SqlParameter name/value constructor treat 0 as null?
  26. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  27. .net connection pooling
  28. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  29. Passing array to a SQL Server Stored Procedure
  30. Why does var evaluate to System.Object in “foreach (var row in table.Rows)”?

Leave a Comment