📄 周路db_studentupdata.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="周路DB_StudentUpdata.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:选课系统ConnectionString %>"
SelectCommand="SELECT [学号] FROM [学生表]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:选课系统ConnectionString2 %>"
DeleteCommand="DELETE FROM [学生表] WHERE [学号] = @学号" InsertCommand="INSERT INTO [学生表] ([学号], [姓名], [性别], [专业], [密码]) VALUES (@学号, @姓名, @性别, @专业, @密码)"
SelectCommand="SELECT * FROM [学生表] WHERE ([学号] = @学号)" UpdateCommand="UPDATE [学生表] SET [姓名] = @姓名, [性别] = @性别, [专业] = @专业, [密码] = @密码 WHERE [学号] = @学号">
<DeleteParameters>
<asp:Parameter Name="学号" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="专业" Type="String" />
<asp:Parameter Name="密码" Type="String" />
<asp:Parameter Name="学号" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="学号" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="学号" Type="Int32" />
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="专业" Type="String" />
<asp:Parameter Name="密码" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="Label1" runat="server" Style="font-weight: bold;
font-size: xx-large; color: #ffffff" Text="学生信息" Width="136px"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
DataTextField="学号" DataValueField="学号">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="添加" /><br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="学号"
DataSourceID="SqlDataSource2" Height="208px" Width="584px">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<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="密码" />
</Columns>
</asp:GridView>
</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);" 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>
<div style="z-index: 104; left: 216px; width: 96px; position: absolute; top: 192px;
height: 16px">
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -