When did they stop using gun powder?

They didn't. Modern cartridges or "bullets" still contain gunpowder inside the shell casing.

The first gun powder integrated cartridge was invented in 1808, but it didn't really catch on until around the time of the American Civil War.