Pretty much any 10-15' cable will do. Looking on Newegg, I'd probably go with the Link Depot one for $20. I do have a 25ft AMC VGA cable that works perfectly though.
Concerning connections, provided your PC has a DVI port and your graphics card is capable of displaying HDCP content. Then all you would need is a DVI to HDMI cable (this assumes your HDTV does have two HDMI ports - One for the cable/satellite box, one for the PC).
Hope this helps,