You can do that if you get a TV tuner card (or simply TV card). I don't think they are called "tv out card". Since most modern video cards have tv-out, I doubt there is a separate card for it. Anyways, once you get a TV card, you can hook up your DVD-player/consoles/anything with s-video or composite out and output the video via software on your computer. But the resulting image quality is nowhere close to pretty, so uh... unless you absolutely must, I'd suggest get a DVD-ROM.
__________________
To all emulator authors and contributors: without your hard work, we'd be without many hours of enjoyment and unable to relive fond memories of childhood. Thank you.