1
<%...@ Page Language="C#" AutoEventWireup="true" CodeFile="guanli.aspx.cs" Inherits="guanli" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5<html xmlns="http://www.w3.org/1999/xhtml" >
6<head runat="server">
7 <title>无标题页</title>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div align="center">
12 <table align="center">
13 <tr>
14 <td colspan="3" style="height: 183px">
15 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
16 DataKeyNames="id" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None"
17 Width="678px" AllowPaging="True" AllowSorting="True">
18 <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
19 <Columns>
20 <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
21 SortExpression="id" />
22 <asp:BoundField DataField="question" HeaderText="question" SortExpression="question" />
23 <asp:BoundField DataField="A" HeaderText="A" SortExpression="A" />
24 <asp:BoundField DataField="B" HeaderText="B" SortExpression="B" />
25 <asp:BoundField DataField="C" HeaderText="C" SortExpression="C" />
26 <asp:BoundField DataField="D" HeaderText="D" SortExpression="D" />
27 <asp:BoundField DataField="answer" HeaderText="answer" SortExpression="answer" />
28 <asp:CommandField ShowEditButton="True" />
29 </Columns>
30 <RowStyle BackColor="#EFF3FB" Font-Size="12px" />
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" Font-Size="12px" />
35 <AlternatingRowStyle BackColor="White" />
36 </asp:GridView>
37 </td>
38 </tr>
39 <tr>
40 <td style="width: 656px; height: 21px" align="left">
41 <asp:DetailsView ID="DetailsView1" runat="server" BackColor="White" BorderColor="#DEDFDE"
42 BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="id" DataSourceID="AccessDataSource1"
43 ForeColor="Black" GridLines="Vertical" Height="50px" Width="125px">
44 <FooterStyle BackColor="#CCCC99" />
45 <EditRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
46 <RowStyle BackColor="#F7F7DE" Font-Size="12px" />
47 <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
48 <Fields>
49 <asp:CommandField ShowInsertButton="True" />
50 </Fields>
51 <HeaderStyle BackColor="#6B696B" Font-Bold="True" Font-Size="12px" ForeColor="White" />
52 <AlternatingRowStyle BackColor="White" />
53 </asp:DetailsView>
54 请按ID的顺序增加记录</td>
55 <td style="width: 486px; height: 21px">
56 </td>
57 <td style="width: 548px; height: 21px">
58 </td>
59 </tr>
60 <tr>
61 <td style="width: 656px; height: 21px">
62 <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="退出管理" /></td>
63 <td style="width: 486px; height: 21px">
64 </td>
65 <td style="width: 548px; height: 21px">
66 </td>
67 </tr>
68 </table>
69
70 </div>
71 <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/database.mdb"
72 SelectCommand="SELECT [id], [question], [A], [B], [C], [answer], [D] FROM [question]" DeleteCommand="DELETE FROM [question] WHERE [id] = ?" InsertCommand="INSERT INTO [question] ([id], [question], [A], [B], [C], [answer], [D]) VALUES (?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE [question] SET [question] = ?, [A] = ?, [B] = ?, [C] = ?, [answer] = ?, [D] = ? WHERE [id] = ?">
73 <DeleteParameters>
74 <asp:Parameter Name="id" Type="Int32" />
75 </DeleteParameters>
76 <UpdateParameters>
77 <asp:Parameter Name="question" Type="String" />
78 <asp:Parameter Name="A" Type="String" />
79 <asp:Parameter Name="B" Type="String" />
80 <asp:Parameter Name="C" Type="String" />
81 <asp:Parameter Name="answer" Type="String" />
82 <asp:Parameter Name="D" Type="String" />
83 <asp:Parameter Name="id" Type="Int32" />
84 </UpdateParameters>
85 <InsertParameters>
86 <asp:Parameter Name="id" Type="Int32" />
87 <asp:Parameter Name="question" Type="String" />
88 <asp:Parameter Name="A" Type="String" />
89 <asp:Parameter Name="B" Type="String" />
90 <asp:Parameter Name="C" Type="String" />
91 <asp:Parameter Name="answer" Type="String" />
92 <asp:Parameter Name="D" Type="String" />
93 </InsertParameters>
94 </asp:AccessDataSource>
95 </form>
96</body>
97</html>
98
OnlineTestSystem/guanli.aspx，打开代码结构图
打包下载该项目完整源码：在线考试系统源码及论文
