secondanswer.aspx

毕业设计+图书管理系统+源码 需要的人下载。

<%@ Page Language="VB" MasterPageFile="~/Administrator/adminMasterPage.master" AutoEventWireup="false" CodeFile="SecondAnswer.aspx.vb" Inherits="Administrator_SecondAnswer"  %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    &nbsp;
    <table id="TABLE1" style="width: 100%; height: 100%; 
border-right: #cc3333 thin solid; 
table-layout: fixed; border-top: #cc3333 thin solid; 
border-left: #cc3333 thin solid; 
border-bottom: #cc3333 thin solid; 
background-color: #cc9966;"
     >
     <caption><h2>记录二次复审</h2></caption>
        <tr>
            <td align="center" style="width: 100%">
                <asp:DropDownList ID="DropDownList1" runat="server" Width="124px" AutoPostBack="True">
                    <asp:ListItem>答辩优秀学生</asp:ListItem>
                    <asp:ListItem>答辩未过学生</asp:ListItem>
                    <asp:ListItem>优秀以及未过</asp:ListItem>
                </asp:DropDownList>
                <asp:DropDownList ID="DropDownList2" runat="server" Width="82px" AutoPostBack="True">
                    <asp:ListItem>每页显示</asp:ListItem>
                    <asp:ListItem>10</asp:ListItem>
                    <asp:ListItem>30</asp:ListItem>
                    <asp:ListItem>50</asp:ListItem>
                    <asp:ListItem>不分页</asp:ListItem>
                </asp:DropDownList></td>
        </tr>
        <tr>
            <td align="center" style="width: 100%">


<asp:Panel id="Excellence" runat="server" Height="50px" Width="125px">
    <asp:GridView ID="gvExcellence" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="SubjectNo" DataSourceID="SqlDataSource2" Width="782px">
        <Columns>
            <asp:BoundField DataField="SubjectNo" HeaderText="课题编号" ReadOnly="True" SortExpression="SubjectNo" />
            <asp:BoundField DataField="SubjectTitle" HeaderText="课题名称" SortExpression="SubjectTitle" />
            <asp:BoundField DataField="StudentNo" HeaderText="学号" SortExpression="StudentNo" />
            <asp:BoundField DataField="UserName" HeaderText="姓名" SortExpression="UserName" />
            <asp:BoundField DataField="AnswerTeamNO" HeaderText="答辩小组号" SortExpression="AnswerTeamNO" />
            <asp:BoundField DataField="DirectorTeacherNo" HeaderText="指导教师编号" SortExpression="DirectorTeacherNo" />
            <asp:BoundField DataField="AnswerScore" HeaderText="成绩" SortExpression="AnswerScore" />
        </Columns>
    </asp:GridView>
    &nbsp;<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:GDMSConnectionString %>"
        SelectCommand="SELECT subject.SubjectNo, subject.SubjectTitle, subject.DirectorTeacherNo, &#13;&#10;      subject.AnswerTeamNO, subject.StudentNo, subject.AnswerScore, &#13;&#10;      users.UserName&#13;&#10;FROM users INNER JOIN&#13;&#10;      subject ON users.UserID = subject.StudentNo&#13;&#10;WHERE (subject.AnswerScore = '优秀')">
    </asp:SqlDataSource>
    &nbsp;&nbsp;
   
</asp:Panel>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td align="center" style="width: 100%">
<asp:panel id="UnPass" runat="server" Visible="False">
    <asp:GridView ID="gvUnpass" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" DataKeyNames="SubjectNo" DataSourceID="SqlDataSource1" Width="784px">
        <Columns>
            <asp:BoundField DataField="SubjectNo" HeaderText="课题编号" ReadOnly="True" SortExpression="SubjectNo" />
            <asp:BoundField DataField="SubjectTitle" HeaderText="课题名称" SortExpression="SubjectTitle" />
            <asp:BoundField DataField="StudentNo" HeaderText="学号" SortExpression="StudentNo" />
            <asp:BoundField DataField="UserName" HeaderText="姓名" SortExpression="UserName" />
            <asp:BoundField DataField="AnswerTeamNO" HeaderText="答辩小组号" SortExpression="AnswerTeamNO" />
            <asp:BoundField DataField="DirectorTeacherNo" HeaderText="指导教师编号" SortExpression="DirectorTeacherNo" />
            <asp:BoundField DataField="AnswerScore" HeaderText="成绩" SortExpression="AnswerScore" />
        </Columns>
    </asp:GridView>
    &nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GDMSConnectionString %>"
        SelectCommand="SELECT subject.SubjectNo, subject.SubjectTitle, subject.DirectorTeacherNo, &#13;&#10;      subject.AnswerTeamNO, subject.StudentNo, subject.AnswerScore, &#13;&#10;      users.UserName&#13;&#10;FROM users INNER JOIN&#13;&#10;      subject ON users.UserID = subject.StudentNo&#13;&#10;WHERE (subject.AnswerScore = '不及格')">
    </asp:SqlDataSource>
</asp:panel> &nbsp;
            </td>
        </tr>
    </table>
</asp:Content>