员工学历信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版2.master" AutoEventWireup="false" CodeFile="员工学历信息.aspx.vb" Inherits="员工学历信息" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <br />
    <table border="1" Width=60%>
        <tr>
            <td style="width: 330px" >
    请选择您要查询的员工号：</td>
            <td style="width: 100px">
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1" DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList></td>
            <td style="width: 100px">
                <asp:Button ID="Button1" runat="server" Text="查询" /></td>
        </tr>
    </table>
    <br />
    <asp:GridView ID="GridView1" runat="server" Width=60%>
    </asp:GridView>
    <br />
    <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
        DataKeyNames="员工号" DataSourceID="AccessDataSource3" PageSize="5" Width=60%>
        <Columns>
            <asp:BoundField DataField="员工号" HeaderText="员工号" ReadOnly="True" SortExpression="员工号" />
            <asp:BoundField DataField="学历" HeaderText="学历" SortExpression="学历" />
            <asp:BoundField DataField="专业" HeaderText="专业" SortExpression="专业" />
            <asp:BoundField DataField="毕业时间" HeaderText="毕业时间" SortExpression="毕业时间" />
            <asp:BoundField DataField="毕业学校" HeaderText="毕业学校" SortExpression="毕业学校" />
            <asp:BoundField DataField="语种" HeaderText="语种" SortExpression="语种" />
        </Columns>
    </asp:GridView>
    <asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT * FROM [员工学历信息表]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT * FROM [员工基本信息表]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号] FROM [员工学历信息表]"></asp:AccessDataSource>
</asp:Content>