how often should you drink a soda sprite coke etc.?

and is diet coke any bad to drink for your health?

I drink Caffeine free Diet Coke as often as possible.
As a diabetic I think Diet Coke (Caffeine free) is a good option rather than death due to diabetic complications!

[...]