📄 guanli.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="guanli.aspx.cs" Inherits="guanli" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<table align="center">
<tr>
<td colspan="3" style="height: 183px">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="id" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None"
Width="678px" AllowPaging="True" AllowSorting="True">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="question" HeaderText="question" SortExpression="question" />
<asp:BoundField DataField="A" HeaderText="A" SortExpression="A" />
<asp:BoundField DataField="B" HeaderText="B" SortExpression="B" />
<asp:BoundField DataField="C" HeaderText="C" SortExpression="C" />
<asp:BoundField DataField="D" HeaderText="D" SortExpression="D" />
<asp:BoundField DataField="answer" HeaderText="answer" SortExpression="answer" />
<asp:CommandField ShowEditButton="True" />
</Columns>
<RowStyle BackColor="#EFF3FB" Font-Size="12px" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Font-Size="12px" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
</tr>
<tr>
<td style="width: 656px; height: 21px" align="left">
<asp:DetailsView ID="DetailsView1" runat="server" BackColor="White" BorderColor="#DEDFDE"
BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="id" DataSourceID="AccessDataSource1"
ForeColor="Black" GridLines="Vertical" Height="50px" Width="125px">
<FooterStyle BackColor="#CCCC99" />
<EditRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F7DE" Font-Size="12px" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<Fields>
<asp:CommandField ShowInsertButton="True" />
</Fields>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" Font-Size="12px" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:DetailsView>
请按ID的顺序增加记录</td>
<td style="width: 486px; height: 21px">
</td>
<td style="width: 548px; height: 21px">
</td>
</tr>
<tr>
<td style="width: 656px; height: 21px">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="退出管理" /></td>
<td style="width: 486px; height: 21px">
</td>
<td style="width: 548px; height: 21px">
</td>
</tr>
</table>
</div>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/database.mdb"
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] = ?">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="question" Type="String" />
<asp:Parameter Name="A" Type="String" />
<asp:Parameter Name="B" Type="String" />
<asp:Parameter Name="C" Type="String" />
<asp:Parameter Name="answer" Type="String" />
<asp:Parameter Name="D" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="Int32" />
<asp:Parameter Name="question" Type="String" />
<asp:Parameter Name="A" Type="String" />
<asp:Parameter Name="B" Type="String" />
<asp:Parameter Name="C" Type="String" />
<asp:Parameter Name="answer" Type="String" />
<asp:Parameter Name="D" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -