In order for your school band fundraiser to go well, it needs to be something that the band members will get excited about. Sure, things like candy fundraisers have been done a million times before, but there's a reason for that - people love chocolate! Any school band fundraiser involving chocolate is bound to be a hit with the kids as well as the adults. If you set up a situation where the kids can sell chocolate to the other kids at lunch or after school... well, you can almost taste the potential for profit there.
It can also be fun to try something new, a school band fundraiser that isn't one of the standard ones. A lot of school bands are having amazing success with things like scratch cards. Scratch cards have high profit percentages, and work especially well for small groups. But more importantly, people love the concept of scratch cards as band fundraising, and that makes them popular as well as profitable.
School band fundraisers don't have to be boring, and in fact your fundraiser is more likely to do well if it's something that everyone is enthusiastic about. If you aim for the type of fundraisers that suit the size and style of your group, and make sure that all the people involved can have fun with fundraising, not only will your school band fundraiser be a financial success, but next year when it comes around again, people will remember what fun last year's fundraiser was, and the momentum of that will lead to repeated success.