Skip to content

Instantly share code, notes, and snippets.

@vrySantosh

vrySantosh/Catching SQL Server Exception

Last active July 20, 2020 10:23
Download ZIP

Revisions

  1. vrySantosh revised this gist Jul 20, 2020. No changes.
  2. vrySantosh created this gist Jul 20, 2020.
    15 changes: 15 additions & 0 deletions Catching SQL Server Exception
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    StringBuilder errorMessages = new StringBuilder();
    catch (SqlException ex)
    {
    for (int i = 0; i < ex.Errors.Count; i++)
    {
    errorMessages.Append("Index #" + i + "\n" +
    "Message: " + ex.Errors[i].Message + "\n" +
    "LineNumber: " + ex.Errors[i].LineNumber + "\n" +
    "Source: " + ex.Errors[i].Source + "\n" +
    "Procedure: " + ex.Errors[i].Procedure + "\n");
    }
    Console.WriteLine(errorMessages.ToString());
    }