Memory card error when in Digital camera and won't show up when in pc.Help?

You have just found out that the memory card is not a permanent storage device. To retrieve those files, you will have to avail of Recovery Services offered by some computer repair shops. You can risk doing it on your own using Recovery Programs downloaded from the internet though if you insist.