addscore.aspx

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

<%@ Page Language="C#" MasterPageFile="~/teacher/TeacherIndex.master" AutoEventWireup="true" CodeFile="Addscore.aspx.cs" Inherits="Work_Addscore" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table id="TABLE1" border="0" cellpadding="0" cellspacing="0" onclick="return TABLE1_onclick()"
        style="border-right: #0099ff 0.1mm solid; border-top: #0099ff 0.1mm solid; font-size: 14px;
        border-left: #0099ff 0.1mm solid; width: 100%; border-bottom: #0099ff 0.1mm solid">
        <tr>
            <td align="center" colspan="3" style="height: 18px">
                学生成绩录入</td>
        </tr>
        <tr>
            <td align="center" style="width: 227px; height: 26px">
                选择学生系别：</td>
            <td style="height: 26px" colspan="2">
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource1"
                    DataTextField="Xiname" DataValueField="Xiname" Width="158px">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td align="center" style="width: 227px; height: 26px">
                选择学生专业：</td>
            <td style="height: 26px" colspan="2">
                <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="AccessDataSource2"
                    DataTextField="zhuanyename" DataValueField="zhuanyename" Width="157px">
                </asp:DropDownList>
            </td>
        </tr>
        <tr style="color: #000000">
            <td align="center" style="width: 227px; height: 26px">
                选择教授课程：</td>
            <td style="height: 26px" colspan="2">
                <asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="AccessDataSource3"
                    DataTextField="Cname" DataValueField="Cname" Width="157px">
                </asp:DropDownList>
            </td>
        </tr>
        <tr style="color: #000000">
            <td align="center" style="width: 227px; height: 26px">
                选择上课学生：</td>
            <td style="height: 26px" colspan="2">
                <asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="AccessDataSource4"
                    DataTextField="Sname" DataValueField="Sname" Width="157px">
                </asp:DropDownList>
            </td>
        </tr> <tr style="color: #000000">
            <td align="center" style="height: 27px" colspan="3">
                填写成绩</td>
        </tr><tr style="color: #000000">
            <td align="center" style="height: 22px" colspan="3">
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
        </tr><tr style="color: #000000">
            <td align="center" style="height: 22px" colspan="3">
                <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" Width="51px">提交</asp:LinkButton></td>
        </tr>
    </table>
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/database/xuanke.mdb"
        SelectCommand="SELECT * FROM [Xi]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/database/xuanke.mdb"
        SelectCommand="SELECT * FROM [zhuanye]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/database/xuanke.mdb"
        SelectCommand="SELECT [Cname] FROM [JiaoyanshiClass] WHERE ([Cteacher] = ?)">
        <SelectParameters>
            <asp:SessionParameter Name="Cteacher" SessionField="tname" Type="String" />
        </SelectParameters>
    </asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/database/xuanke.mdb"
        SelectCommand="SELECT [Sname], [Szhuanye] FROM [Student]"></asp:AccessDataSource>
</asp:Content>