//********************************************************************************************************************** //FUNCTION: takes an error number returned by a SQL stored procedure and returns the error message associated with it //********************************************************************************************************************** public static string GetSqlErrorMessage(int errorNo) { //check for custom errors switch (ErrorNo) { case 1: return "A duplicate record already exists in the database."; default: //check for an error message defined in the sysmessages table using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString)) { using (var command = new SqlCommand("SELECT [Description] FROM master.dbo.sysmessages WHERE msglangid = 1033 AND Error = @ErrorNo", connection)) { command.Parameters.Add(new SqlParameter("@ErrorNo", errorNo)); command.Open(); object errorMessage = command.ExecuteScalar(); if (errorMessage != null) { return errorMessage.ToString(); } else { return "The error number has not been recognised."; } } } } }