温馨提示:代码在线浏览功能只能做为源码浏览参考,不能展示项目的全部,如果想更进一步了解该代码请下载:Asp.net简单网络选课系统源码
当前文件路径:MyElectCourse/studentElect.aspx

1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="studentElect.aspx.cs" Inherits="StudentElect" %> 2
3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 4
5
<html xmlns="http://www.w3.org/1999/xhtml" > 6
<head runat="server"> 7
<title>ElectCource</title> 8
</head> 9
<body leftmargin="0" rightmargin="0"> 10
<form id="form1" runat="server"> 11
<div> 12
<table id=table1 width=400 border=0 align=center> 13
<tr> 14
<td align=center> 15
<span style="font-size: 16pt; font-family: 隶书"> 16
可选修课程</span></td> 17
</tr> 18
<tr> 19
<td> 20
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" Width=100% 21
BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" 22
DataSourceID="SqlDataSource1" GridLines="Vertical" OnRowCommand="GridView1_RowCommand" Font-Size="10pt" DataKeyNames="courceID,teaID" > 23
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> 24
<RowStyle BackColor="#EEEEEE" ForeColor="Black" Font-Size="10pt" /> 25
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> 26
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> 27
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" Font-Size="10pt" /> 28
<AlternatingRowStyle BackColor="Gainsboro" /> 29
<Columns> 30
<asp:BoundField DataField="courceID" HeaderText="courceID" ReadOnly="True" Visible=False SortExpression="courceID" /> 31
<asp:BoundField DataField="teaID" Visible=False HeaderText="teaID" ReadOnly="True" SortExpression="teaID" /> 32
<asp:BoundField DataField="courceName" HeaderText="课程名称" SortExpression="courceName"> 33
<ItemStyle Width="70px" Wrap="False" /> 34
<HeaderStyle Wrap="False" /> 35
</asp:BoundField> 36
<asp:BoundField DataField="teaName" HeaderText="教师姓名" SortExpression="teaName"> 37
<ItemStyle Width="70px" Wrap="False" /> 38
<HeaderStyle Wrap="False" /> 39
</asp:BoundField> 40
<asp:BoundField DataField="courceTime" HeaderText="上课时间" SortExpression="courceTime"> 41
<ItemStyle Width="70px" Wrap="False" /> 42
<HeaderStyle Wrap="False" /> 43
</asp:BoundField> 44
<asp:BoundField DataField="courceAddress" HeaderText="上课地点" SortExpression="courceAddress"> 45
<ItemStyle Width="70px" Wrap="False" /> 46
<HeaderStyle Wrap="False" /> 47
</asp:BoundField> 48
<asp:HyperLinkField DataNavigateUrlFields="courceID,teaID" DataNavigateUrlFormatString="courseDetail.aspx?courceID={0}&teaID={1}" HeaderText="详细..." Text="详细..." /> 49
<asp:ButtonField HeaderText="选修" CommandName="select" Text="选修"> 50
<ItemStyle Width="30px" Wrap="False" /> 51
<HeaderStyle Wrap="False" /> 52
</asp:ButtonField> 53
</Columns> 54
</asp:GridView> 55
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 56
SelectCommand="SELECT Cource.courceID, Cource.teaID, Cource.courceName, Teacher.teaName, Cource.courceTime, Cource.courceAddress FROM Cource INNER JOIN Teacher ON Cource.teaID = Teacher.teaID WHERE (Cource.courceID NOT IN (SELECT courceID FROM Elect WHERE (stuID = @stuID)))"> 57
<SelectParameters> 58
<asp:SessionParameter Name="stuID" SessionField="userName" /> 59
</SelectParameters> 60
</asp:SqlDataSource> 61
</td> 62
</tr> 63
<tr> 64
<td style="height: 24px; text-align: center"> 65
<span style="font-size: 16pt; font-family: 隶书">您已经选修的课程</span></td> 66
</tr> 67
<tr> 68
<td> 69
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White" Width=100% 70
BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" 71
DataSourceID="SqlDataSource2" GridLines="Vertical" OnRowCommand="GridView2_RowCommand" DataKeyNames="stuID,courceID,teaID"> 72
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> 73
<RowStyle BackColor="#EEEEEE" ForeColor="Black" Font-Size="10pt" /> 74
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> 75
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> 76
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" Font-Size="10pt" /> 77
<AlternatingRowStyle BackColor="Gainsboro" /> 78
<Columns> 79
<asp:BoundField DataField="stuID" HeaderText="stuID" ReadOnly="True" SortExpression="stuID" Visible=False /> 80
<asp:BoundField DataField="courceID" HeaderText="courceID" ReadOnly="True" SortExpression="courceID" Visible=False /> 81
<asp:BoundField DataField="teaID" HeaderText="teaID" ReadOnly="True" SortExpression="teaID" Visible=False /> 82
<asp:BoundField DataField="courceName" HeaderText="课程名称" SortExpression="courceName"> 83
<ItemStyle Width="70px" Wrap="False" /> 84
<HeaderStyle Wrap="False" /> 85
</asp:BoundField> 86
<asp:BoundField DataField="teaName" HeaderText="教师姓名" SortExpression="teaName"> 87
<ItemStyle Width="60px" Wrap="False" /> 88
<HeaderStyle Wrap="False" /> 89
</asp:BoundField> 90
<asp:BoundField DataField="courceTime" HeaderText="上课时间" SortExpression="courceTime"> 91
<ItemStyle Width="60px" Wrap="False" /> 92
<HeaderStyle Wrap="False" /> 93
</asp:BoundField> 94
<asp:BoundField DataField="courceAddress" HeaderText="上课地点" SortExpression="courceAddress"> 95
<ItemStyle Width="60px" Wrap="False" /> 96
<HeaderStyle Wrap="False" /> 97
</asp:BoundField> 98
<asp:ButtonField HeaderText="退选" CommandName="shanchu" Text="退选"> 99
<ItemStyle Width="28px" Wrap="False" /> 100
<HeaderStyle Wrap="False" /> 101
</asp:ButtonField> 102
</Columns> 103
</asp:GridView> 104
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 105
SelectCommand="SELECT Elect.stuID, Elect.courceID, Elect.teaID, Cource.courceName, Teacher.teaName, Cource.courceTime, Cource.courceAddress, Cource.courceInfo FROM Elect INNER JOIN Cource ON Elect.courceID = Cource.courceID AND Elect.teaID = Cource.teaID INNER JOIN Teacher ON Elect.teaID = Teacher.teaID AND Cource.teaID = Teacher.teaID WHERE (Elect.stuID = @stuID)"> 106
<SelectParameters> 107
<asp:SessionParameter Name="stuID" SessionField="userName" /> 108
</SelectParameters> 109
</asp:SqlDataSource> 110
</td> 111
</tr> 112
<tr> 113
<td style="height: 21px" align="center"> 114
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/ModifyPwd.aspx" Font-Size="10pt">修改密码</asp:HyperLink> 115
116
<asp:HyperLink ID="HyperLink2" runat="server" Font-Size="10pt" NavigateUrl="javascript:window.close()">退出系统</asp:HyperLink></td> 117
</tr> 118
</table> 119
</div> 120
</form> 121
</body> 122
</html> 123



