How do you get the trigger result in vb.net

Firstly let me say what an awsome website this is - ive got a project that i need to complete and this site has helped heaps. My project involves building an application with a vb.net front end and an sql server 2000 backend. My problem is that i have created triggers on my table in server 2000 and I was wondering how I would know if they had been triggered when I did something like an insert via VB.net. Would i have been better off creating each trigger as a store procedure and then calling them one at a time before i modifyed data? Would your answer work equally well for different types of triggers (instead of,for,after) Thanks for your help - my aplogies if this has already been answered (im stressing out)

Loader.
Up arrow icon