You'll get more details about other's trials and tribulations in this regard but it seems there's a better success rate if it was from SDHC media than SXS.
Obviously don't use the card. There are's lots of file rescue utilities out there but people have had mixed results I believe so you may have to experiment. We'll see what people list specifically. People have had success though.