Sweet and carbonated is tough. You have to make sure the yeast do not continue to eat the sugars.
If you are kegging, you can stabilize the yeast with campden and sorbate, then add sugar and force carb.
But if you are priming, you need active yeast to turn the priming sugar into bubbles...