There are times when strange things just happen, and it is very hard to track them down. Putting in the TV card might have effected your system in some way. Did you completely power down the system prior to installing the card. Turning it off is not good enough, you need to unplug also.
I did not notice, but your XP drive also has an active partition. If it is encountered first during the boot, you will get the Bootmgr message or some other error, unless you have valid boot files in that partition.
My comments about the logical drives is not a critisim, but an observation that Win 7 could not have set it up that way. You must have had a previous install or used another utility to set up the partitions. The fact you tried the recovery DVD may account for the two active partitions, but only you would know your exact situation.
Disconnecting the drive set to primary in the bios and rebooting sets the other drive to primary. It stays that way until you change the bios, or in some circumstances change the configuration and reboot. So, if you disconnect the primary drive, reconnecting it may not move it back up to primary in the bios.
It appears you have 2 DVD drives. Are they both Sata and which connectors are they on?
And lastly, many motherboards now have 2 SATA controllers. Are you using only the primary controller for your drives?