I have a 2010 Enterprise Farm, and I am attempting to place a Data View Web Part in the Ribbon to display content from an external SQL database as part of a gamification initiative. Basically, I need the DVWP to show a blank/bronze/silver/gold badge icon if the [Current User] has earned one, per the results of a query that hits that external SQL database.
I have created a custom td on the masterpage, and have successfully inserted the DVWP into it. I have successfully displayed the results of a query in that DVWP. Where I'm stuck is on the last two pieces: 1.) Just displaying data for the [Current User] 2.) Displaying the blank/bronze/silver/gold badge icon
I'm relatively new to code, so I suspect I'm missing something obvious. Here's a mockup of what I'm trying to do:
Here's as far as I've gotten:
Any suggestions? Your help is greatly appreciated!!