Super Rod is unnecessary. Dragonair locations in Diamond:
Use Ultra Balls or Dusk Balls (night/cave) for best catch rate. Super Rod only accesses deeper-water species (e.g., Gyarados, Milotic).