choosesubject.aspx

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

<%@ Page Language="VB" MasterPageFile="~/student/studentMasterPage.master" AutoEventWireup="false" CodeFile="ChooseSubject.aspx.vb" Inherits="student_ViewProjectDetail"  %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#DEDFDE"
        BorderStyle="None" BorderWidth="1px" CellPadding="4" DataSourceID="SqlDataSource1"
        ForeColor="Black" GridLines="Vertical" Height="137px" Style="position: relative"
        Width="98%" AllowPaging="True" AutoGenerateColumns="False">
        <FooterStyle BackColor="#CCCC99" />
        <RowStyle BackColor="#F7F7DE" />
        <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
        <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="SubjectNo" HeaderText="课题编号" ReadOnly="True" SortExpression="SubjectNo" />
            <asp:BoundField DataField="SubjectTitle" HeaderText="课题名称" SortExpression="SubjectTitle" />
            <asp:BoundField DataField="DirectorTeacherNo" HeaderText="教师编号" SortExpression="DirectorTeacherNo" />
            <asp:BoundField DataField="UserName" HeaderText="教师姓名" SortExpression="UserName" />
        </Columns>
    </asp:GridView>
    &nbsp;
    <table style="left: 2px; width: 763px; position: relative; top: -12px; height: 106px">
        <tr>
            <td style="width: 22px; height: 14px">
             <asp:Label ID="Label4" runat="server" Style="position: relative; left: 10px; top: 0px;" Text="请输入你要选择的课题"
                    Width="176px"></asp:Label>
            </td>
            <td style="width: 365px; height: 14px">
                <asp:Label ID="Label6" runat="server" Style="position: relative" Text="课题名称" Width="73px"></asp:Label></td>
            <td style="width: 180px; height: 14px">
                <asp:Label ID="Label7" runat="server" Style="position: relative; top: 0px;" Text="教师编号"></asp:Label></td>
        </tr>
        <tr>
            <td style="width: 22px; height: 13px" >           
            <asp:Label ID="Label1" runat="server" Text="1" Width="20px"></asp:Label></td>
            <td style="width: 365px; height: 9px">
                <asp:TextBox ID="TextBox1" runat="server" Style="position: relative; left: 5px; top: 25px;" Width="327px"></asp:TextBox></td>
            <td style="width: 180px; height: 9px">
                <asp:TextBox ID="TextBox5" runat="server" Style="position: relative; left: 1px; top: 27px;"></asp:TextBox></td>
        </tr>
        <tr>
            <td style="width: 22px; height: 13px">
                <asp:Label ID="Label2" runat="server" Style="left: 162px; position: relative; top: 30px"
                    Text="3" Width="20px"></asp:Label></td>
            <td style="width: 365px; height: 13px">
                <asp:TextBox ID="TextBox2" runat="server" Style="position: relative; left: 4px; top: -31px;" Width="328px"></asp:TextBox></td>
            <td style="width: 180px; height: 13px">
                <asp:TextBox ID="TextBox6" runat="server" Style="position: relative; left: 0px; top: -29px;"></asp:TextBox></td>
        </tr>
        <tr>
            <td style="width: 20px">
                <asp:Label ID="Label3" runat="server" Style="left: 162px; position: relative; top: -27px"
                    Text="2" Width="18px"></asp:Label></td>
            <td style="width: 365px">
                <asp:TextBox ID="TextBox3" runat="server" Style="position: relative; left: 4px;" Width="329px"></asp:TextBox></td>
            <td style="width: 180px">
                <asp:TextBox ID="TextBox7" runat="server" Style="position: relative"></asp:TextBox></td>
        </tr>
        <tr> <td colspan=3 align="center">
        <asp:Button ID="Button1" runat="server" Height="44px"
        Text="确认选择课题" Width="139px" />
        </td></tr>
    </table>
    
 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GDMSConnectionString %>"
        SelectCommand="SELECT subject.DirectorTeacherNo, subject.SubjectTitle, subject.SubjectNo, users.UserName FROM subject INNER JOIN users ON subject.DirectorTeacherNo = users.UserID WHERE (subject.StudentNo IS NULL)">
    </asp:SqlDataSource>
</asp:Content>