Slightly different than you asked, but you can associate sounds to your application through the control panel and they will be handled automatically by Windows.

(Like when your program crashes, or when question windows are popped up).

I can tell you how if you are interested.