📄 chakanzuoye.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="chakanzuoye.aspx.vb" Inherits="chakanzuoye" %>
<!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>
<style type="text/css">
<!--
body,td,th {
font-size: 10pt;
color: #000000;
}
body {
background-color: #00CCFF;
}
-->
</style></head>
<body style="background-image: url(图片/7d8e3733deed41f41b4cffc0.jpg)">
<form id="form1" runat="server">
<div>
<p> </p>
<p style="color: red">老师您的用户名是：<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></p>
<p style="color: red">欢迎使用本教务系统</p>
<p>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="AccessDataSource1" Height="184px" Width="520px">
<Columns>
<asp:BoundField DataField="yonghuming" HeaderText="学生名" SortExpression="yonghuming" />
<asp:BoundField DataField="kechm" HeaderText="课程名" SortExpression="kechm" />
<asp:BoundField DataField="班级" HeaderText="班级" SortExpression="班级" />
<asp:BoundField DataField="成绩" HeaderText="成绩" SortExpression="成绩" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" Visible="False" />
<asp:BoundField DataField="jiaoshiming" HeaderText="jiaoshiming" SortExpression="jiaoshiming"
Visible="False" />
<asp:CommandField ButtonType="Button" ShowEditButton="True" />
</Columns>
</asp:GridView>
</p>
<div style="z-index: 101; left: 504px; width: 272px; position: absolute; top: 344px;
height: 312px; font-weight: bold; color: yellow;">
该学生的作业是<br />
<asp:TextBox ID="TextBox1" runat="server" Height="222px" Width="192px"></asp:TextBox></div>
<p>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/db1.mdb"
SelectCommand="SELECT [yonghuming], [kechm], [班级], [成绩], [ID], [jiaoshiming] FROM [xskc] WHERE ([jiaoshiming] = ?)" DeleteCommand="DELETE FROM [xskc] WHERE [ID] = ? AND [yonghuming] = ? AND [kechm] = ? AND [班级] = ? AND [成绩] = ? AND [jiaoshiming] = ?" InsertCommand="INSERT INTO [xskc] ([yonghuming], [kechm], [班级], [成绩], [ID], [jiaoshiming]) VALUES (?, ?, ?, ?, ?, ?)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [xskc] SET [yonghuming] = ?, [kechm] = ?, [班级] = ?, [成绩] = ?, [jiaoshiming] = ? WHERE [ID] = ? AND [yonghuming] = ? AND [kechm] = ? AND [班级] = ? AND [成绩] = ? AND [jiaoshiming] = ?" ConflictDetection="CompareAllValues">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_yonghuming" Type="String" />
<asp:Parameter Name="original_kechm" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_成绩" Type="String" />
<asp:Parameter Name="original_jiaoshiming" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="yonghuming" Type="String" />
<asp:Parameter Name="kechm" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="成绩" Type="String" />
<asp:Parameter Name="jiaoshiming" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_yonghuming" Type="String" />
<asp:Parameter Name="original_kechm" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_成绩" Type="String" />
<asp:Parameter Name="original_jiaoshiming" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="yonghuming" Type="String" />
<asp:Parameter Name="kechm" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="成绩" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="jiaoshiming" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:SessionParameter Name="jiaoshiming" SessionField="yonghuming" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:Button ID="Button1" runat="server" Text="返回" /></p>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -