CF Card failure - a bit different

I’m furious because I’ve lost 3 cards so far. They are all Sandisk 32 Gig cards. I shot with one and the same day my computer won’t recognize the card. Then I put it in my camera and it says that I need to format the card. So I can’t get video clips off the card now. I was working for a client so this is not cool. I was told not to fill up the card by a guy working at Calumet in Boston. Don’t you allthink that Sandisk should be responsible for getting our data back? Any tips on making sure cards don’t fail would be much appreciated.