pass sql trigger values to windows application

Question

i have a table in MS SQL with following collumns.

Table name - ITEMS
Columns - ITEM_ID,ITEM_NAME,QTY,UNIT_PRICE


i want to send a sms when  a certain item QTY
decreased to 50 from C# windows application.
So i have written a trigger.
CREATE TRIGGER LOW_STOCK AFTER UPDATE OF QTY ON ITEM REFERENCING NEW AS N FOR EACH ROW WHEN (N.QTY<50) SIGNAL SQLSTATE '75000' SET MESSAGE_TEXT='LOW QTY' i want to pass the low stock ITEM_ID s to the windows app.What can i do??Please help me.Thank u very much.