i know its fire when we insert,update,delete in table. But what its use in asp.net application. Because Trigger fire on SQL server.

& why we use trigger for insert/update/delete?