Is my hard drive at a point I can no longer use it?

I built my buddy a computer a few months back and he has since let it get consumed by virii to the point that it would barely boot.  I took out the drive and connected it to my computer.  The drive has two partitions.  When I went to boot up my computer it tried to boot off his drive.  I changed the bios settings to that the computer would boot off my drive but it would still boot from his drive.  I then unhooked my drive so his drive was the only one connected.  I booted up with a Knoppix Linux DVD and was able to browse the drive.  I deleted some files out of the root of the primary partition.  I then hooked up my drive again and was able to boot to my drive but Vista did not recognize his drive.  I started up computer management and went to disk management and after a long delay it recognized the drive but would spit back an error when I tried to initialize it.  The next thing I tried was to unhook my drive and boot from an XP cd.  I tried to have it format the drive but that didn't work either.  I thought maybe I had deleted the mbr when I was running Linux so I booted the xp cd and went to the command prompt and did a fixmbr command but that did not work.  Is the drive dead?  It's a good drive (Western Digital Caviar SE16 WD5000AAKS 500GB 7200 RPM SATA 3.0Gb/s) so I would like to get it running again.  Any ideas on how to fix it with or without the data?