Besides video, you will also need to transport sound from your notebook to the TV set, using your notebook's headphone jack. The DVI connection has no sound.
There are cables with one end having 3.5 mm stereo jack and the other end having two RCA connectors. You need one such cable.
Where you connect the RCA connectors for sound on the TV set is important. You must read the TV manual and choose matched set for both video and sound. Otherwise, you do not get either sound or video on the TV set.
If your TV has HDMI port and you are going to use DVI-to-HDMI adapter cable ( as advised by CompTIA_Rep above ), choose only the HDMI port on the TV set for which you can also connect external sound input.