Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
C# / SQL

How to use SQL RAISEERROR() messages in C#

- 21.10.21 - ErcanOPAK
DECLARE @MyValue int

SELECT @MyValue = Column1 WHERE Column2 > 50

IF @MyValue IS NULL
BEGIN
    RAISEERROR('This is my custom message from SQL.', 16, 1)
END
ELSE
   SELECT MyValue
END

Use an error code within 11-16, or just use 16 for a “general” case.

RAISERROR('This is my custom message from SQL.',16,1)

Why? Here’s summary of https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities?view=sql-server-2017:

SQL RAISERROR -> C#:

  • 0-10 = fyi*
  • 11-16 = you can fix it**
  • 17-19 = get admin help
  • 20-24 = definitely get admin help***

*(don’t throw anything) ┬──┬

**(16 = general)

***(fatal error)

Thanks hchiam

try
{
    // Write your data access code here
}
catch (SqlException ex)
{
    string errorMessage =  ex.Message;
    int errorCode =  ex.ErrorCode;
}

 

Related posts:

How to solve 'incorrect syntax near the keyword WITH' problem?
What does COALESCE do in SQL?
Get the row number "x" from SQL
How to set Tooltip for a particular Devexpress Gridview Column
Null-Conditional (?) and Null-Coalescing (??) Operators in C#
Post Views: 0

Post navigation

How to check column data types of a table in SQL
Change some value inside List

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (223)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (177)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (168)

Recent Posts

  • How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio
  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently

Recent Posts

  • How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio
  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (223)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme