📄 kecheng.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="kecheng.aspx.vb" Inherits="kecheng" %>
<!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">
<Columns>
<asp:BoundField DataField="课程名称" HeaderText="课程名称" SortExpression="课程名称" />
<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:BoundField DataField="课程简介" HeaderText="课程简介" SortExpression="课程简介" />
<asp:CommandField ButtonType="Button" ShowEditButton="True" />
<asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/db1.mdb"
SelectCommand="SELECT [课程名称], [开课时间], [班级], [ID], [jiaoshiming], [课程简介] FROM [kecheng] WHERE ([jiaoshiming] = ?)" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [kecheng] WHERE [ID] = ? AND [课程名称] = ? AND [开课时间] = ? AND [班级] = ? AND [jiaoshiming] = ? AND [课程简介] = ?" InsertCommand="INSERT INTO [kecheng] ([课程名称], [开课时间], [班级], [ID], [jiaoshiming], [课程简介]) VALUES (?, ?, ?, ?, ?, ?)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [kecheng] SET [课程名称] = ?, [开课时间] = ?, [班级] = ?, [jiaoshiming] = ?, [课程简介] = ? WHERE [ID] = ? AND [课程名称] = ? AND [开课时间] = ? AND [班级] = ? AND [jiaoshiming] = ? AND [课程简介] = ?">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_课程名称" Type="String" />
<asp:Parameter Name="original_开课时间" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_jiaoshiming" Type="String" />
<asp:Parameter Name="original_课程简介" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="课程名称" Type="String" />
<asp:Parameter Name="开课时间" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="jiaoshiming" Type="String" />
<asp:Parameter Name="课程简介" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_课程名称" Type="String" />
<asp:Parameter Name="original_开课时间" Type="String" />
<asp:Parameter Name="original_班级" Type="String" />
<asp:Parameter Name="original_jiaoshiming" Type="String" />
<asp:Parameter Name="original_课程简介" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="课程名称" Type="String" />
<asp:Parameter Name="开课时间" Type="String" />
<asp:Parameter Name="班级" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="jiaoshiming" Type="String" />
<asp:Parameter Name="课程简介" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:SessionParameter Name="jiaoshiming" SessionField="yonghuming" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
</p>
<p>
发布课程</p>
<p>
课 程 名<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></p>
<p>
开 始 时 间<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></p>
<p>
班 级<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></p>
<p>
<asp:Button ID="Button1" runat="server" Text="提交" />
<asp:Button ID="Button2" runat="server" Text="返回" /></p>
<p>
</p>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -