Exemplo n.º 1
0
		//**********************************************************************************************************************
		//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.";
							}
						}
					}
			}
		}