Where do you need to use triggers?

Question

Hi,

Where do we need to use triggers,how do we decide on that in case  in asp.net application. Please give examples in order to understand it better.