📄 老师查询选课的学生的信息——李晨华.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="老师查询选课的学生的信息——李晨华.aspx.vb" 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>
<script language="javascript" type="text/javascript">
// <!CDATA[
// ]]>
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<div style="z-index: 101; left: -2px; width: 100px; position: absolute; top: 4px;
height: 100px">
<img src="图片/题头.jpg" width="1005" height="120" /></div>
<div style="z-index: 103; left: -2px; width: 100px; position: absolute; top: 122px;
height: 100px"><img src="图片/底色.jpg" width="1005" height="900" id="IMG1" onclick="return IMG1_onclick()" />
<div style="font-weight: bold; font-size: 250%; z-index: 105; left: 320px; text-transform: uppercase;
width: 384px; color: #003399; font-style: normal; font-family: 隶书; position: absolute;
top: 64px; height: 56px">
选修本课程学生信息</div>
<div style="z-index: 104; left: 208px; width: 200px; position: absolute; top: 168px;
height: 168px">
课程号<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
DataTextField="课程号" DataValueField="课程号">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:选修课管理系统ConnectionString %>"
SelectCommand="SELECT DISTINCT 课程号 FROM 选修表 ORDER BY 课程号"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None" Height="184px" Width="760px">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<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" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:选修课管理系统ConnectionString %>"
SelectCommand="SELECT * FROM [老师查询_学生信息] WHERE ([课程号] = @课程号) ORDER BY [课程号], [学号]">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="课程号" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<div style="z-index: 103; left: 824px; width: 48px; position: absolute; top: 80px;
height: 32px">
<asp:Button ID="Button4" runat="server" Text="注销" Width="59px" /></div>
</div>
<div style="z-index: 102; left: -5px; width: 100px; position: absolute; top: 123px;
height: 100px"><img src="图片/导航树底色.jpg" width="190" height="900" /> </div>
</div>
<div style="z-index: 104; left: -4px; width: 100px; position: absolute; top: 122px;
height: 100px"><img src="图片/导航树底色.jpg" width="190" height="900" />
<div style="z-index: 101; left: 31px; width: 100px; position: absolute; top: 165px;
height: 100px">
<asp:TreeView ID="TreeView1" runat="server" Height="130px" ImageSet="BulletedList4" ShowExpandCollapse="False">
<Nodes>
<asp:TreeNode NavigateUrl="~/Default2.aspx" Text="查询课程信息" Value="查询课程信息"></asp:TreeNode>
<asp:TreeNode NavigateUrl="~/Default3.aspx" Text="添加修改学生分数" Value="添加修改学生分数"></asp:TreeNode>
<asp:TreeNode Text="返回主页" Value="返回主页"></asp:TreeNode>
<asp:TreeNode Text="安全退出" Value="安全退出"></asp:TreeNode>
</Nodes>
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" />
<SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px"
VerticalPadding="0px" />
<NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="5px"
NodeSpacing="0px" VerticalPadding="0px" />
</asp:TreeView>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -