yes, you'll need
this adapter as mentioned above, but in addition I think you should get
this cable (change length as needed) for sound.
Not necessary you Macbook Pro does output sound on that mini-display plug, so second cable is in my opinion a necessary ebil.
@jinjuku: Are you sure he needs HDMI-DVI cable for new tv??
@mtbound10 - You'd probably want to check Plex software or Boxee Beta for Mac which should be out next month