What program is best to run for making a map and how do i get the sprites for the sandbags,etc...

the easiest way to do it

Valve Hammer Editor
http://collective.valve-erc.com/index.php?go=hammer_beta

Get "Hammer Beta" and "Day of Defeat FGD".

You said something about getting sandbag sprites....well, they're models not sprites, but you'll need a couple things to have access to all of them...

GCF Scape
http://countermap.counter-strike.net/Nemesis/files/files/gcfscape114beta.zip

Use this to access all the files in the "day of defeat.gcf" megafile.

DotNexFX
http://www.microsoft.com/downloads/details.aspx?FamilyId=262D25E3-F589-4842-8157-034D1E7CF3A3&displaylang=en

You'll need this to run GCFScape

Half Life Model Veiwer
http://www.swissquake.ch/chumbalum-soft/files/hlmv125.zip

Use this to veiw models.

Zoner's Half Life Tools
http://collective.valve-erc.com/data/docs/1034150354-69206000/files/zhlt253-17.zip

You'll need this to compile your maps and make them playable inside DoD

HOW TO SET IT UP
http://www.mardymouse.co.uk/modules.php?name=Content&pa=showpage&pid=1

MardyMouse has many tutorials for new mappers, use them as your guide.

If you have any more questions, contact me on AIM or MSN...

AIM : LeperMessiah181
MSN : dodlepermessiah@hotmail.com

Cheers.