📄 xs.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="XS.aspx.cs" 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>
<table style="border-right: #999999 thin solid; border-top: #999999 thin solid; background-attachment: fixed;
left: 20%; background-image: url(img/backgroud1.jpg); border-left: #999999 thin solid;
width: 534px; border-bottom: #999999 thin solid; position: absolute; top: 20%;
height: 266px; z-index: 108;">
<tr>
<td style="background-image: none; width: 29px; height: 267px">
<asp:Button ID="Button1" runat="server" BackColor="Control" BorderStyle="Outset"
OnClick="Button1_Click" Style="z-index: 100; left: 18px; position: absolute;
top: 86px" Text="查询已选课程" Width="90px" ForeColor="SeaGreen" />
<asp:Button ID="Button5" runat="server" BackColor="Control" Style="z-index: 101;
left: 18px; position: absolute; top: 203px" Text="查询个人信息" Width="90px" OnClick="Button5_Click" ForeColor="SeaGreen" />
<asp:Button ID="Button3" runat="server" BackColor="Control" OnClick="Button3_Click1"
Style="z-index: 103; left: 18px; position: absolute; top: 145px" Text="查询所有"
Width="90px" ForeColor="SeaGreen" />
</td>
<td style="background-image: none; width: 100px; height: 267px">
<asp:Label ID="Label1" runat="server" ForeColor="White" Style="z-index: 100; left: 309px;
position: absolute; top: 37px" Text="学生界面" Width="70px"></asp:Label>
<asp:Label ID="Label2" runat="server" Height="8px" Style="z-index: 101; left: 152px;
position: absolute; top: 112px" Text="课程号：" Width="65px" ForeColor="SeaGreen"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Height="15px" Style="z-index: 102; left: 252px;
position: absolute; top: 111px" Width="100px"></asp:TextBox>
<asp:Label ID="Label3" runat="server" Style="z-index: 103; left: 152px; position: absolute;
top: 172px" Text="课程名：" Width="65px" ForeColor="SeaGreen"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server" Height="15px" Style="z-index: 104; left: 252px;
position: absolute; top: 171px" Width="100px"></asp:TextBox>
<asp:Button ID="Button2" runat="server" BackColor="Control" Style="z-index: 105;
left: 400px; position: absolute; top: 110px" Text="确定" OnClick="Button2_Click" ForeColor="SeaGreen" />
<asp:Button ID="Button4" runat="server" BackColor="Control" Style="z-index: 106;
left: 400px; position: absolute; top: 169px" Text="确定" OnClick="Button4_Click" ForeColor="SeaGreen" />
<asp:Button ID="Button6" runat="server" BackColor="Control" OnClick="Button6_Click"
Style="z-index: 107; left: 461px; position: absolute; top: 109px" Text="添加" ForeColor="SeaGreen" />
<asp:Button ID="Button7" runat="server" BackColor="Control" Style="z-index: 109;
left: 462px; position: absolute; top: 169px" Text="添加" OnClick="Button7_Click" ForeColor="SeaGreen" />
</td>
</tr>
</table>
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="UCnumber" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
Style="z-index: 100; left: 272px; position: absolute; top: 446px" Visible="False"
Width="476px" AutoGenerateDeleteButton="True">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="UCnumber" HeaderText="编号" ReadOnly="True" SortExpression="UCnumber" />
<asp:BoundField DataField="Cnumber" HeaderText="课程号" SortExpression="Cnumber" />
<asp:BoundField DataField="Uaccouts" HeaderText="用户号" SortExpression="Uaccouts" />
<asp:BoundField DataField="Uname" HeaderText="用户名" SortExpression="Uname" />
<asp:BoundField DataField="Cname" HeaderText="课程名" SortExpression="Cname" />
</Columns>
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:courseConnectionString4 %>"
SelectCommand="SELECT * FROM [UserCourseInformation] WHERE ([Uaccouts] = @Uaccouts)" DeleteCommand="DELETE FROM [UserCourseInformation] WHERE [UCnumber] = @UCnumber" InsertCommand="INSERT INTO [UserCourseInformation] ([UCnumber], [Cnumber], [Uaccouts], [Uname], [Cname]) VALUES (@UCnumber, @Cnumber, @Uaccouts, @Uname, @Cname)" UpdateCommand="UPDATE [UserCourseInformation] SET [Cnumber] = @Cnumber, [Uaccouts] = @Uaccouts, [Uname] = @Uname, [Cname] = @Cname WHERE [UCnumber] = @UCnumber">
<SelectParameters>
<asp:SessionParameter Name="Uaccouts" SessionField="Uaccouts" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="UCnumber" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Cnumber" Type="String" />
<asp:Parameter Name="Uaccouts" Type="String" />
<asp:Parameter Name="Uname" Type="String" />
<asp:Parameter Name="Cname" Type="String" />
<asp:Parameter Name="UCnumber" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="UCnumber" Type="Int32" />
<asp:Parameter Name="Cnumber" Type="String" />
<asp:Parameter Name="Uaccouts" Type="String" />
<asp:Parameter Name="Uname" Type="String" />
<asp:Parameter Name="Cname" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:Label ID="Label4" runat="server" Font-Names="楷体_GB2312" Font-Size="X-Large"
ForeColor="#8080FF" Height="38px" Style="z-index: 101; left: 377px; position: absolute;
top: 73px" Text="欢迎来到个人课程管理系统" Width="429px"></asp:Label>
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="Cnumber" DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None"
Style="z-index: 102; left: 257px; position: absolute; top: 456px" Visible="False"
Width="506px">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -