How to get message from sql trigger to UI from in C#

Question

Hello I am working on C# Windows Application project. I have created trigger which will fire a message after inserting data into table. I want to display that message on my Window Form in message box. How can this be achieved in C# windows application form? Thank & Regards Suraj

Bikesh Srivastava · Answer

I think you need to create a procedurefunction and return message and show on ui

Mayank · Answer

Hi Suraj You need to create a Procedure that will insert rows in DB. After insertion trigger will fire and procedure return a parameter in to C# that u can display in UI.

Chetan Ranpariya · Answer

Hi Suraj How's yor trigger look like? How does it send message? Did you try anything by yourself to solve this? Are you facing any issue with your approach? Thanks and regards Chetan Ranpariya