Comment 5 from puppypusher is also okay. Return the hardware back to its original configuration. If the second partition shows up, make a backup first, and then make your changes.
Obviously, since the first partition is still showing up, I am going to assume that the drive platters and electronics are still working fine, in which case, your data is still there (unless you did something really dumb like overwrite the second partition with a new partition and new data).
Hopefully, the lesson learned is to always make (and test) a backup copy of any data that you can't stand losing, before making significant hardware and software changes.
If Windows was noticing the second partition this thread wouldn't be here.
Return the hardware back to its original configuration.
If that worked I wouldn't be asking.
Disk manager is not part of Explorer it is part of system tools. It looks at physical drives and shows how they a partitioned including usb drives. It will see the drive space even if it dose not have a letter assigned.