As mentioned, a TV tuner card is what you want. ATI and nVidia are the two most common brands, they both offer "integrated" cards meaning that the tuner is right on the video card itself. Hauppauge makes TV-tuner-only cards meaning that you still need a video card for the computer monitor or LCD panel that comes with the computer.
The advantage to the integrated cards is that they're easier to set up inside the machine but the software that comes with them can be clunky to use, so most people wind up getting additional software that doesn't suck, like the Windows MCE mentioned above. The Hauppauge has better software but because it's a second card, it can be a pain to get installed, but once it's up and running you're golden.