score.aspx

智能选课系统:本程序采用Microsoft Visual Studio 2005集成环境开发即 asp.net 2.0+access 数据库开发。 功能如下:学校中学生教师根据不同的权限合理分配,提

<%@ Page Language="C#" MasterPageFile="~/student/Student.master" AutoEventWireup="true" CodeFile="Score.aspx.cs" Inherits="studnet_Score" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <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">
        <tr>
            <td align="center" colspan="3" style="width: 549px; border-bottom: #66ccff 0.1mm solid;
                height: 18px">
                所有课程成绩</td>
        </tr>
        <tr>
            <td colspan="3" rowspan="4" style="width: 549px; height: 123px" valign="top">
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                    DataKeyNames="Sid" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None"
                    Width="545px">
                    <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                    <Columns>
                        <asp:BoundField DataField="Sid" HeaderText="编号" InsertVisible="False" ReadOnly="True"
                            SortExpression="Sid" />
                        <asp:BoundField DataField="Skecheng" HeaderText="课程名称" SortExpression="Skecheng" />
                        <asp:BoundField DataField="Sscore" HeaderText="成绩" SortExpression="Sscore" />
                        <asp:BoundField DataField="Sxibie" HeaderText="系别" SortExpression="Sxibie" />
                        <asp:BoundField DataField="Szhuanye" HeaderText="专业" SortExpression="Szhuanye" />
                    </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:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/database/xuanke.mdb"
                    SelectCommand="SELECT * FROM [Score] WHERE ([Sstudentname] = ?)">
                    <SelectParameters>
                        <asp:SessionParameter Name="Sstudentname" SessionField="sname" Type="String" />
                    </SelectParameters>
                </asp:AccessDataSource>
            </td>
        </tr>
        <tr>
        </tr>
        <tr>
        </tr>
        <tr>
        </tr>
        <tr>
            <td align="center" colspan="3" style="width: 549px; height: 19px">
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>