What is the difference between fat-soluble and water-soluble vitamins?

What is the difference between fat-soluble and water-soluble vitamins? Give some examples, John is a soccer player. He is taking mega doses of vitamins. What are the dangers of this? Are no vitamins good for us?