troubleshooting Question

ASP.NET Gridview images

Avatar of thomasmutton
thomasmuttonFlag for United Kingdom of Great Britain and Northern Ireland asked on
ASP.NET
13 Comments3 Solutions522 ViewsLast Modified:
Hello experts.

I have an SQL statement that says
SELECT TOP 3 *
FROM tbl_UserProfile
ORDER BY UserLoginCount DESC

and it outputs the 3 people with the highest number of logins.

This works and the gridview works fine too but I would like to put an image column in there for 1st, 2nd and 3rd place.

so 1st = gold medal
2nd = silver medal
3rd = bronze medal

How can I do this?
Thanks
<asp:GridView ID="GridView1" runat="server" 
                        DataSourceID="SqlDataSource1" 
                        AutoGenerateColumns="False"  
                        DataKeyNames="UserProfileId"
                        SkinID="TopUsersThisMonth" style="float: left; margin: 0px 0px 10px 0px;">
                        <Columns>
                            <asp:BoundField HeaderText="Pos"  />
                            <asp:BoundField DataField="UserFirstName" HeaderText="User" />
                            <asp:BoundField DataField="UserLoginCount" HeaderText="Logins" />
                        </Columns>
                        <EmptyDataTemplate>There are currently no training modules.</EmptyDataTemplate>
                    </asp:GridView>
Page-1.jpg
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 13 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros