📄 周路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 + -