The prince went to meet her, took her by the hand and danced with her. He would dance with no other maiden, and never left loose of her hand, and if any one else came to invite her, he said, "This is my partner."
Endymion/Mamoru/Tuxedo Kamen of Sailor Moon; particularly in the manga but generally fits this role in any of the franchise's incarnations.
James of Pokémon's Team Rocket has shades of this, with a little Gentleman Thief for good measure. Given that he's from a rich, affluent family, it sort of fits.
Negima Neo has Fate, playing it straight just to make Negi jealous.
Comicbooks
Bill Willingham's comic book Fables (about characters from fairy tales living in secret in New York) has Prince Charming, who was married three times, to Snow White, Sleeping Beauty, and Cinderella. He's a bit of a Magnificent Bastard and eventually becomes Mayor of Fabletown.
It's arguably both played straight and subverted - he is undeniably charming royalty and arguably a decent ruler, but, as it's specified at one point, He's Prince Charming - not "Prince Dependable" much less "Prince Faithful," which of course explains the multiple wives. He's both blessed and cursed to be Exactly What It Says on the Tin.
The Queen of Fables thinks that Superman is Prince Charming and wants to either kill him or marry him. Maybe both. Given his nature, it's understandable that the delusional Queen would make this mistake.
It should be noted that in Snow White and Cinderella the prince does little more than show up and be royal, Phillip on the other hand, is the only one with an actual charming character.
Inverted in the Shrek sequels, as Prince Charming is vain, selfish and in Shrek the Third, arguably evil.
Films — Live-Action
Prince Edward from Enchanted is Prince Charming Played for Laughs. He's good-natured, handsome, and heroic, but he's kind of thick. And it turns out he's not the right man for Giselle—but when he realizes this, he gallantly steps aside for her true prince.
Played straight in Prince Charming a 2001 made-for-television film starring Sean Maguire is the story of a prince who gets turned into a frog because he dashingly rescues a damsel in distress who starts trying to reward him.
Kate and Leopold has Prince Leopold, Duke of Albany who writes the best apology letter in the history of mankind.
In the Czech movie Byl jednou jeden král (Once upon a time there was a king, an adaptation of the fairy tale Salt over gold) there are three princes who came to the kingdom as suitors for the three princesses: Prince Charming note who claims to be THE Prince Charming who rescued the Sleeping Beauty and the Snow White (but, contrary to what the fairy tales say, he didn't marry them), Prince Valiant, and Prince Cunning. They are all braggarts and cowards, and eventually they help themselves to the royal treasure - while the three princesses, as well as the king himself, get married to commoners in the end.
Literature
Given how soon it was written after the term originated, The Picture of Dorian Gray is likely one of the first subversions. Dorian is called this by extremely naiveactress Sybil who he seduces and abandons, driving to suicide. Another lover also apparently called him this, and uses the nickname scornfully when he encounters her several years later as a prostitute.
Ella Enchanted exaggerates this. The prince's name is Charmont, which is sorta like Charming and borders on charmant, which is French for "charming" and comes from the Fairy Tale "The Blue Bird" where the hero was called Le Roi Charmant ("the charming king"). He prefers to be called Char, though.
John Moore's Slay and Rescue has a professional hero who really is a prince named Charming, sent by his father's chancellor to rescue fair maidens all over the place (the theory is that it keeps him too busy to try to take over the throne). He's Genre Savvy, deliberately pulls Big Damn Heroes arrivals, has Implausible Fencing Powers, and is very frustrated. Nonetheless, he's also basically decent.
The likes of Rhaegar Targaryen whose love for a woman he was not betrothed to incited Robert's Rebellion and the Wrong Genre Savvy Quentyn Martell.
In Terry Pratchett's Unseen Academicals, Glenda objects to Trev as Juliet's love because Juliet is special and all she needed was a prince — and she remembers her own fantasies. Juliet and Trev do end up together, and Glenda ends up with a king to be.
Justified in the contemporary book Dream Boy written by Ann Reit, which stars a charming, but immature teenager who learned it from his father.
Played straight with Prince Jonathan of the realm of Tortall who is a lover and a fighter. And oh boy is he a lover - right up until he meets Thayet, anyway, and she steals his heart and his ability to speak in all of ten seconds.
Elisabeth: The Princess Bride where Emperor Franz Joseph I, was able to win over Elisabeth because she consired him to be playful, considerate and charming.
Also in Isabel: Jewel of Castilla where it takes less than two hours for Fernando, Prince of Aragon and King of Sicily, to steal the princess's heart with his humor, authority and imagination.
Prince Charming is a character in Sesame Street, using the same puppet as Guy Smiley and Don Music, who can be relied upon to totally mess up any fairy-tale he's involved in (he's not a Prince Charmless, just incompetent and not very bright). He also works as a dance instructor, under the name Prince Cha-Cha-Charming.
Nate Archibald is all but explicitly based on this trope. He is described as charming with extreme regularity, and has the tendency to fall passionately in love (with various girls) and deliver romantic speeches (occasionally hilariously out of context) while rescuing them from some emotional or social dragon. He is in the books given the epithet "prince of the upper east side" and it is said that he can "snap his fingers and have any girl he wants." If you gave him fencing lessons, he would basically be the Prince Charming from Fables
In the musical episode of Buffy the Vampire Slayer, "Once More With Feeling", Buffy rescues a handsome prince, in an inversion of the traditional rescue scenario. He sings "How can I repay—" but Buffy cuts him off with "Whatever" given that she's in her depressed period.
Justified for Logan from Gilmore Girls who is his father's heir, charismatic, and quite a ladies man.
Played straight in Veronica Mars "Ain't No Magic Mountain High Enough" where Logan meets Hannah who he says is "like the hot daughter of a king he marries off to get like Denmark or something."
Imitated/played for laughs so to speak on Bones "The Prince in the Plastic", which had a victim who created a doll called 'Prince Charmington' and a suspect who dressed as the doll for store openings and such.
The main Prince in Once Upon a Time, James, is sarcastically (at first) nicknamedPrince Charming by his future wife, Snow White, when he captures her in a net. She says that he's so charming if that's the only way he can get someone. Of course she did steal from him.
Pretty much all the princes in the series fit the trope, including Cinderella's and Sleeping Beauty's Princes. Probably a rare instance in modern television where the trope is played straight for the most part, although James turns out secretly not to be of legit royal blood.
The "Dream Prince" in Akumu-chan is a deliberate example of this trope. He is handsome, charming, rides a horse, and seems to exist for the sole purpose of rescuing Ayami from her troubled dreams and wooing her.
He appears in Go Go Sentai Boukenger to any lady who wore the Glass Slipper. He then traps her in his world with the help of one of Cinderella's Stepsisters. His true form is that of a monster, and he is killed off by the Boukengers.
Theatre
Into the Woods actually has two examples: there are two Prince Charmings, married to Cinderella and Rapunzel, respectively. In the second act, they abandon their wives for Snow White and Sleeping Beauty.
"I was raised to be charming, not sincere." - Cinderella's Prince
Videogames
Fable III: The Male Hero looks like a classic example of this Trope
Psychonauts's official Psycho-Pedia has this to say about Lili's view of Raz:
Ultra Fast Pony inverts this without invoking Prince Charmless. Prince Blueblood is handsome royalty and a perfect gentlestallion. Unfortunately, the heroine Rarity has a mile-wide masochistic streak, so she wants a prince who will boss her around and hurt her. Rarity loses interest in Prince Blueblood because he's too nice.
Webcomics
Gil from Girl Genius is a kind of reconstruction. The Prince Charming has often been deconstructed by making him (the heir of) a tyrant. But Gil is very good at arguing his father is the most enlightened despot in the continent, and he's probably right. Also, Gil is beautiful, the ultimate warrior, Always Save the Girl… He just fails for the romantic side.
The Foster's Home for Imaginary Friends episode "Frankie, My Dear" has a Prince Charming imaginary friend. He is indeed handsome, charming, romantic—and smitten with Frankie Foster. Frankie tells him that she outgrew his type years ago, but don't worry, Friends like him get snatched up by little girls in no time.