The best treatment for nerve pain, ultimately, is to manage your diabetes well. In fact, a major study by the American Diabetes Association in 2006 showed that strict blood glucose control with intensive insulin therapy lowered the chances of having symptoms of peripheral neuropathy - tingling, burning, and pain - by 64%. While you can't control whether or not you get diabetic nerve pain, you can help control your glucose levels with diet, exercise, and mediations if you need them.
Instructed in various factors that help alleviate pain without, or in addition to, analgesics such as frequent position changes, relaxation techniques, heat or cold, regular rest periods, pillows to support painful area, etc.