sql server Trigger

i know how to create trigger but i want to know how to call them from asp.net web application?

thank you,

Triggers automatically fires, when you perform any operations on the table. U can write triggers for Insert,Update and delete.
There are two types of trigger u can write.
1. After
2. Instead of

By default it is after. I am writing some code for creating trigger.

 

CREATE TRIGGER MySample ON [TableName]
FOR DELETE
AS
IF (SELECT state FROM deleted) = ‘SomeValue’
BEGIN
PRINT ‘Can not remove customers from SomeValue’
PRINT ‘Transaction has been canceled’
ROLLBACK
END

It's the after trigger.

I think it will help you.