Loading

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

Suraj Kumbhar

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayank9y ago
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.
Bikesh Srivastava9y ago
I think you need to create a procedure,function and return message and show on ui
Chetan Ranpariya9y ago
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