if it can be fermented, it can be primed with. Although the conversions are not always the same. To reach the same volumes of CO2 with corn sugar vs table sugar vs DME vs turbinado vs maple syrup vs honey vs. agave syrup vs. invert syrup vs. whatever else folks have primed with, each one will require a different amount, and have a different impact. Generally the generic "sugars", the corn sugar, the table sugar, etc, won't have a flavor impact. Other sugars will have a flavor impact. Some that are completely fermentable won't affect the body or anything like that. Some, like DME, that are not fully fermentable, will increase the body slightly. Corn sugar (dextrose) are table sugar (sucrose) are the most common ones and the easiest and most neutral to work with.
Just search for "priming sugar calculator" on your friendly Googling Machine, and you'll find a number of different calculators out there. You put in the volume you're bottling (not the batch size, but the bottled volume- I usually assume about a 10% loss to the yeast cake- for 5 gallons of beer in the fermenter, I enter 4.5 gallons as the bottled volume, and I get as close as I can), the temperature of the beer, and the amount of carbonation you want (it really varies by style, but 2.5 volumes is a good middle of the road number that'll work for a lot of styles) and it'll tell you how much sugar you need.
And then a day after bottling will not make for carbonated beer even if you primed it. It'll take a week or so for the CO2 to develop, and then 3 weeks is the best timeframe for it to actually balance out (any sooner than that, and it'll blow off most of the CO2 when you open it, foaming too much and leaving a flatter beer behind). For best results, bottle it, store it in the dark at about 70 degrees, let it sit at 70 for 3 weeks, then a few days in the fridge after that before pouring it.
Although there's some other ways to do things. There's ways to prime with wort (krausening), or by blending beers and then bottling (a la Gueuze) some English brewers will transfer to a cask when there's still a few points left to attenuate, and then seal it and carbonate it that way. Although given the initial question and the follow up post, I'm guessing you probably dont' yet have the experience to make any of those a good idea at this point. More likely to end badly (or even dangerously) if you don't know what you're doing.