?? 周路db_studentsearch.aspx
字號:
?<%@ Page Language="VB" AutoEventWireup="false" CodeFile="周路DB_StudentSearch.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>
</head>
<body>
<form id="form1" runat="server">
<div style="background-image: url(圖片/底色.jpg);">
<br />
<br />
<br />
<div style="z-index: 101; left: 16px; background-image: url(圖片/題頭.jpg); width: 976px;
position: absolute; top: 16px; height: 120px">
</div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="z-index: 103; left: 200px; width: 792px; position: absolute; top: 136px;
height: 736px; background-color: transparent;">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:選課系統ConnectionString5 %>"
DeleteCommand="DELETE FROM [課程表] WHERE [課程號] = @課程號" InsertCommand="INSERT INTO [課程表] ([課程號], [課程名], [學分], [學時], [上課時間], [上課地點], [開課學期], [已選人數], [限選人數], [教師編號]) VALUES (@課程號, @課程名, @學分, @學時, @上課時間, @上課地點, @開課學期, @已選人數, @限選人數, @教師編號)"
SelectCommand="SELECT * FROM [課程表]" UpdateCommand="UPDATE [課程表] SET [課程名] = @課程名, [學分] = @學分, [學時] = @學時, [上課時間] = @上課時間, [上課地點] = @上課地點, [開課學期] = @開課學期, [已選人數] = @已選人數, [限選人數] = @限選人數, [教師編號] = @教師編號 WHERE [課程號] = @課程號">
<DeleteParameters>
<asp:Parameter Name="課程號" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="課程名" Type="String" />
<asp:Parameter Name="學分" Type="Int32" />
<asp:Parameter Name="學時" Type="Int32" />
<asp:Parameter Name="上課時間" Type="String" />
<asp:Parameter Name="上課地點" Type="String" />
<asp:Parameter Name="開課學期" Type="DateTime" />
<asp:Parameter Name="已選人數" Type="Int32" />
<asp:Parameter Name="限選人數" Type="Int32" />
<asp:Parameter Name="教師編號" Type="Int32" />
<asp:Parameter Name="課程號" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="課程號" Type="Int32" />
<asp:Parameter Name="課程名" Type="String" />
<asp:Parameter Name="學分" Type="Int32" />
<asp:Parameter Name="學時" Type="Int32" />
<asp:Parameter Name="上課時間" Type="String" />
<asp:Parameter Name="上課地點" Type="String" />
<asp:Parameter Name="開課學期" Type="DateTime" />
<asp:Parameter Name="已選人數" Type="Int32" />
<asp:Parameter Name="限選人數" Type="Int32" />
<asp:Parameter Name="教師編號" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:Label ID="Label1" runat="server" Style="font-weight: bold; font-size: xx-large;
color: #ffffff" Text="選課信息"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
DataKeyNames="課程號" DataSourceID="SqlDataSource1" Width="656px" CellPadding="4" ForeColor="#333333" GridLines="None" Height="424px">
<Columns>
<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="開課學期" />
<asp:BoundField DataField="已選人數" HeaderText="已選人數" SortExpression="已選人數" />
<asp:BoundField DataField="限選人數" HeaderText="限選人數" SortExpression="限選人數" />
<asp:BoundField DataField="教師編號" HeaderText="教師編號" SortExpression="教師編號" />
</Columns>
<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>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:選課系統ConnectionString9 %>"
SelectCommand="SELECT [課程號] FROM [課程表]"></asp:SqlDataSource>
<br />
<br />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Label ID="Label2" runat="server" Text="學號"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
DataTextField="課程號" DataValueField="課程號" Width="96px">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="提交" />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/DB_StudentADD.aspx">查看</asp:HyperLink></div>
<br />
<br />
<div style="z-index: 102; left: 16px; width: 184px; position: absolute; top: 136px;
height: 736px">
<asp:TreeView ID="TreeView1" runat="server" ExpandDepth="0" Height="736px" ShowLines="True"
Style="background-image: url(圖片/導航樹底色.jpg); background-color: #99ccff" Width="184px">
<Nodes>
<asp:TreeNode Checked="True" ShowCheckBox="False" Text="用戶" Value="用戶">
<asp:TreeNode Text="教師" Value="教師">
<asp:TreeNode Text="添加" Value="添加"></asp:TreeNode>
<asp:TreeNode Text="查詢" Value="查詢"></asp:TreeNode>
<asp:TreeNode Text="刪除" Value="刪除"></asp:TreeNode>
<asp:TreeNode Text="更新" Value="更新"></asp:TreeNode>
</asp:TreeNode>
<asp:TreeNode Text="學生" Value="學生">
<asp:TreeNode Text="添加" Value="添加"></asp:TreeNode>
<asp:TreeNode Text="查詢" Value="查詢"></asp:TreeNode>
<asp:TreeNode Text="刪除" Value="刪除"></asp:TreeNode>
<asp:TreeNode Text="更新" Value="更新"></asp:TreeNode>
</asp:TreeNode>
</asp:TreeNode>
<asp:TreeNode Text="課程" Value="課程">
<asp:TreeNode Text="添加" Value="添加"></asp:TreeNode>
<asp:TreeNode Text="查詢" Value="查詢"></asp:TreeNode>
<asp:TreeNode Text="刪除" Value="刪除"></asp:TreeNode>
<asp:TreeNode Text="更新" Value="更新"></asp:TreeNode>
</asp:TreeNode>
<asp:TreeNode Text="公告" Value="公告">
<asp:TreeNode Text="添加" Value="添加"></asp:TreeNode>
<asp:TreeNode Text="修改" Value="修改"></asp:TreeNode>
<asp:TreeNode Text="刪除" Value="刪除"></asp:TreeNode>
</asp:TreeNode>
</Nodes>
</asp:TreeView>
</div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</div>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -