Will I have to get poked with a needle when I get a transrectal ultrasound with prostate biopsy?

Yes. Biopsy means taking a small sample of tissue to be examined under a microscope. This is often done using a special needle.
Yes. You will get poked in the arm for an iv, to give you meds, and you will get poked in your prostate (several times) for the biopsies.