I tried Band in a Box, can't say it did anything for me...
I'm using Cakewalk Sonar LE. This came as a combo with a Roland Duo Capture recording interface, retailing at around R1200 but got it on a deal for about R800. Fantastic software, as long as you're willing to take a bit of time to actually learn to do the stuff...
It's fairly simple once you've figured the controls. Insert a MIDI track in the program, select what instrument you want it to be, then program in the notes in the "Piano roll" view.
It's a rather poor example, because I was in a hurry, but if you listen to a track I did for this month's competition at this link:
http://www.box.com/s/oy4m3r5f1n3sgsax9mgr , I programmed the drums in as a MIDI file in my software...