If a radioactive spider bites me, will I be able to climb walls and fight crime?

I'd like to know if this has happened to anyone and what the outcome was. Did you gain superpowers or just die from radiation poisoning?