📄 default.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1"
DataTextField="班级" DataValueField="班级" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
DataKeyNames="学号" DataSourceID="AccessDataSource2" Width="670px">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="学号" HeaderText="学号" ReadOnly="True" SortExpression="学号" />
<asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
<asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" />
<asp:BoundField DataField="班级" HeaderText="班级" SortExpression="班级" />
<asp:BoundField DataField="数学" HeaderText="数学" SortExpression="数学" />
<asp:BoundField DataField="语文" HeaderText="语文" SortExpression="语文" />
<asp:BoundField DataField="英语" HeaderText="英语" SortExpression="英语" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/db/Students.mdb"
SelectCommand="SELECT DISTINCT [班级] FROM [result]"></asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/db/Students.mdb" DeleteCommand="DELETE FROM [result] WHERE [学号] = ? AND [姓名] = ? AND [性别] = ? AND [班级] = ? AND [数学] = ? AND [语文] = ? AND [英语] = ?"
InsertCommand="INSERT INTO [result] ([学号], [姓名], [性别], [班级], [数学], [语文], [英语]) VALUES (?, ?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [result] WHERE ([班级] = ?)"
UpdateCommand="UPDATE [result] SET [姓名] = ?, [性别] = ?, [班级] = ?, [数学] = ?, [语文] = ?, [英语] = ? WHERE [学号] = ? AND [姓名] = ? AND [性别] = ? AND [班级] = ? AND [数学] = ? AND [语文] = ? AND [英语] = ?">
<DeleteParameters>
<asp:Parameter Name="original_学号" Type="String" />
<asp:Parameter Name="original_姓名" Type="String" />
<asp:Parameter Name="original_性别" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_数学" Type="Int16" />
<asp:Parameter Name="original_语文" Type="Int16" />
<asp:Parameter Name="original_英语" Type="Int16" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="数学" Type="Int16" />
<asp:Parameter Name="语文" Type="Int16" />
<asp:Parameter Name="英语" Type="Int16" />
<asp:Parameter Name="original_学号" Type="String" />
<asp:Parameter Name="original_姓名" Type="String" />
<asp:Parameter Name="original_性别" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_数学" Type="Int16" />
<asp:Parameter Name="original_语文" Type="Int16" />
<asp:Parameter Name="original_英语" Type="Int16" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="班级" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="学号" Type="String" />
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="数学" Type="Int16" />
<asp:Parameter Name="语文" Type="Int16" />
<asp:Parameter Name="英语" Type="Int16" />
</InsertParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/db/Students.mdb"
SelectCommand="SELECT * FROM [result]"></asp:AccessDataSource>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -