ASP.NET Page /Admin/Results.aspx (C#)
Uses Code Behind Page Page /Admin/Results.aspx.cs (C#)
1: <%@ Page Language="C#" AutoEventWireup="true" Inherits="Admin_Results" Codebehind="Results.aspx.cs" %>  
2:   
3:   
4:   
5: <html xmlns="http://www.w3.org/1999/xhtml" >  
6: <head runat="server">  
7:     <title>Admin - Results Maintenance</title>  
8: </head>  
9: <body>  
10:     <form id="form1" runat="server">  
11:     <asp:HyperLink ID="lblHome" runat="server" NavigateUrl="~/Admin/Default.aspx">Home</asp:HyperLink>  
12:     <div>  
13:         <center><asp:HyperLink ID="cmdWHOIS" runat="server" NavigateUrl="http://www.arin.net/whois/" target="_blank"></asp:HyperLink></center>  
14:              
15:         <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"  
16:             AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333"  
17:             GridLines="None" PageSize="50">  
18:             <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />  
19:             <Columns>  
20:                 <asp:BoundField DataField="ResultDate" HeaderText="ResultDate" SortExpression="ResultDate" />  
21:                 <asp:BoundField DataField="TopicCode" HeaderText="TopicCode" SortExpression="TopicCode" />  
22:                 <asp:BoundField DataField="QuestionsCorrect" HeaderText="QuestionsCorrect" SortExpression="QuestionsCorrect" />  
23:                 <asp:BoundField DataField="QuestionsIncorrect" HeaderText="QuestionsIncorrect" SortExpression="QuestionsIncorrect" />  
24:                 <asp:BoundField DataField="Weight" HeaderText="Weight" SortExpression="Weight" />  
25:                 <asp:BoundField DataField="CountryCode" HeaderText="CountryCode" SortExpression="CountryCode" />  
26:                 <asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />  
27:                 <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />  
28:                 <asp:BoundField DataField="IPaddress" HeaderText="IPaddress" ReadOnly="True" SortExpression="IPaddress" />  
29:             </Columns>  
30:             <RowStyle BackColor="#EFF3FB" />  
31:             <EditRowStyle BackColor="#2461BF" />  
32:             <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />  
33:             <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />  
34:             <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />  
35:             <AlternatingRowStyle BackColor="White" />  
36:         </asp:GridView>  
37:         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QuiznetOnline.Data.Properties.Settings.Default.QuizNetOnlineConnectionString %>"  
38:             SelectCommand="SELECT [ResultDate], [TopicCode], [QuestionsCorrect], [QuestionsIncorrect], [Weight], [CountryCode], [Location], [Email],[IPaddress] FROM [Results] where datediff(dd,[ResultDate],getdate())<=30 ORDER BY [ResultDate] desc">  
39:         </asp:SqlDataSource>  
40:       
41:     </div>  
42:     </form>  
43: </body>  
44: </html>  

.NET Documentation Tool is © 2002 - 2009 Winnersh Triangle Web Solutions Limited.