Skip to content

ErcanOPAK.com

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

Tag: handle

C# / SQL

How to use SQL RAISEERROR() messages in C#

- 21.10.21 - ErcanOPAK comment on How to use SQL RAISEERROR() messages in C#

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 […]

Continue Reading ..
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 (334)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (226)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (191)
  • 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)
  • Confirm before process with ASPxButton in Devexpress (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Add Constraint to SQL Table to ensure email contains @ (178)
  • Devexpress ASPxGridview Column Grouping in Code (177)
  • Tense Changes When Using Reported Speech (169)

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 (334)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (226)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (191)
  • 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)

Social

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

powered by XBlog Plus WordPress Theme