With a regular beer, idealy you want to let the fast fermenting sugars and some of the slow fermentin dextrins ferment out before bottling. Under these circumstances a good rule of thumb is to add 1 tsp of sugar, dextrose/glucose/brown sugar etc, per litre to get a good level of carbonation.
You can add as much sugar as you like before bottling but if you let it ferment out it wont effect carbonation, you'll know it has fermented out because you'll get 2 hydrometer readings the same within 24hrs. If you dont let it ferment out you are chancing over carbonation.
This can lead to exploding bottles because as the yeast ferments the sugars it not only produces alcohol but it also produces co2 and therefore too much pressure and potentialy 'bang'!
Just as bad though is a beer that is too lively to pour. An over carbonated beer can foam so much once the bottle is open it will virtualy empty the bottle. You can over come this to a certain extent by chilling the bottles as much as possible as the colder the beer is the more co2 it will absorb and keep in suspension.