?? 老師查詢選課的學生的信息——李晨華.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:選修課管理系統(tǒng)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:選修課管理系統(tǒng)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="添加修改學生分數(shù)" Value="添加修改學生分數(shù)"></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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -