当前文件路径：XuanKeLunWen/student/CourseList.aspx

		            
 1<%...@ Page Language="C#" MasterPageFile="~/student/Student.master" AutoEventWireup="true" CodeFile="CourseList.aspx.cs" Inherits="studnet_CourseList" Title="Untitled Page" %>
 2<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 3 <table border="0" cellpadding="0" cellspacing="0" style="border-right: #66ccff 0.1mm solid; border-top: #66ccff 0.1mm solid;  border-left: #66ccff 0.1mm solid;  border-bottom: #66ccff 0.1mm solid; width: 100%;">
 4            <tr>
 5                <td colspan="3" style="height: 18px; border-bottom: #66ccff 0.1mm solid;" align="center">
 6                    学生课程表</td>
 7            </tr>
 8            <tr>
 9                <td style="height: 24px;" align="center" colspan="3">
10                    必修课</td>
11            </tr>
12            <tr>
13                <td style="height: 198px;" align="left" colspan="3" valign="top">
14                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
15                        DataKeyNames="Classid" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None"
16                        Width="100%">
17                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
18                        <Columns>
19                            <asp:BoundField DataField="Classid" HeaderText="编号" InsertVisible="False" ReadOnly="True"
20                                SortExpression="Classid" />
21                            <asp:BoundField DataField="CClass" HeaderText="系" SortExpression="CClass" />
22                            <asp:BoundField DataField="Czhuanye" HeaderText="专业" SortExpression="Czhuanye" />
23                            <asp:BoundField DataField="Cname" HeaderText="课程名称" SortExpression="Cname" />
24                            <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
25                            <asp:BoundField DataField="CweekBegTime" HeaderText="开始周" SortExpression="CweekBegTime" />
26                            <asp:BoundField DataField="CweekEndTime" HeaderText="结束周" SortExpression="CweekEndTime" />
27                            <asp:BoundField DataField="Cdate" HeaderText="星期" SortExpression="Cdate" />
28                            <asp:BoundField DataField="Ctime" HeaderText="节次" SortExpression="Ctime" />
29                        </Columns>
30                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
31                        <EditRowStyle BackColor="#999999" />
32                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
33                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
34                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
35                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
36                    </asp:GridView>
37                    </td>
38            </tr>
39            <tr>
40                <td style="height: 19px;" align="center" colspan="3">
41                    选修课</td>
42            </tr>
43            <tr>
44                <td style="height: 136px;" colspan="3" valign="top">
45                    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"
46                        DataKeyNames="Classid" DataSourceID="AccessDataSource2" ForeColor="#333333" GridLines="None"
47                        Width="100%">
48                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
49                        <Columns>
50                            <asp:BoundField DataField="Classid" HeaderText="编号" InsertVisible="False" ReadOnly="True"
51                                SortExpression="Classid" />
52                            <asp:BoundField DataField="CClass" HeaderText="系" SortExpression="CClass" />
53                            <asp:BoundField DataField="Czhuanye" HeaderText="专业" SortExpression="Czhuanye" />
54                            <asp:BoundField DataField="Cname" HeaderText="课程名" SortExpression="Cname" />
55                            <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
56                            <asp:BoundField DataField="CweekBegTime" HeaderText="开始周" SortExpression="CweekBegTime" />
57                            <asp:BoundField DataField="CweekEndTime" HeaderText="结束周" SortExpression="CweekEndTime" />
58                            <asp:BoundField DataField="Cdate" HeaderText="星期" SortExpression="Cdate" />
59                            <asp:BoundField DataField="Ctime" HeaderText="节次" SortExpression="Ctime" />
60                        </Columns>
61                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
62                        <EditRowStyle BackColor="#999999" />
63                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
64                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
65                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
66                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
67                    </asp:GridView>
68                    </td>
69            </tr>
70            <tr>
71                <td style="height: 16px;" align="center" colspan="3">
72                    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/database/xuanke.mdb"
73                        SelectCommand="SELECT * FROM [JiaoyanshiClass] WHERE ([Czhuanye] = ?)">
74                        <SelectParameters>
75                            <asp:SessionParameter Name="Czhuanye" SessionField="zhuanye" Type="String" />
76                        </SelectParameters>
77                    </asp:AccessDataSource>
78                    <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/database/xuanke.mdb"
79                        SelectCommand="SELECT * FROM [studentclass] WHERE ([Cstudentname] = ?)">
80                        <SelectParameters>
81                            <asp:SessionParameter Name="Cstudentname" SessionField="sname" Type="String" />
82                        </SelectParameters>
83                    </asp:AccessDataSource>
84                    &nbsp;</td>
85            </tr>
86        </table>
87</asp:Content>
88
89