The movie is about a greaser who dies in a car accident, bargains with God to come back, comes back and goes to prom, then dies in his girlfriends arms. The end is him sitting in a tree with Duke of Earl playing.

I think you are talking about "The Heavenly Kid" starring Jason Gedrick.