My ubuntu partition was deleted and I can't boot from either a DVD or USB

The code that fits in the Drive MBR is very small. In the case of Windows, the bootloader is very simple and merely redirects to the bootsector of the partition with the boot flag set. Grub is a more complicated bootloader, but it's still limited by the space, so it has to load modules from a specific partition (the Ubuntu partition you deleted).

When Grub cannot find those modules (because the partition no longer exists), then you get a very limited grub rescue prompt. It can be used to load grub modules manually, but of course in your case, that's not possible because there is no partition. So there is really nothing you can do (that I am aware of) that will boot the remaining operating system (Windows).

In your case, the simplest way to fix it is to replace the Grub bootloader with a Windows bootloader. You mentioned you have problems booting from DVD and USB, in which case you'll have to figure that out or consider removing your drive to another machine. I think it's pretty unusual for a machine to no longer boot from USB or CD/DVD so I'd try troubleshooting that.

Then you can install the Windows bootloader from a Windows repair prompt (either by booting a Windows repair CD or a Windows Installation DVD) and running:

bootrec /fixmbr

Or you could boot an Ubuntu CD and install a bootloader with equivalent function...

sudo apt-get update
sudo apt-get install lilo
sudo lilo -M /dev/sda mbr

Lilo will give you a big warning after it's installed - but you can ignore that as when it is used as a Windows style bootloader, it works fine as written above.