querybookslostform.aspx

基于C#和MYSQL的图书管理系统

<%--文件名：QueryBooksLostForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="QueryBooksLostForm.aspx.cs" Inherits="QueryManage_QueryBooksLostForm" Title="当前位置：查询管理->查询挂失图书"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 556px; height: 161px">
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
                background-color: darkturquoise">
                &nbsp;开始日期：<asp:TextBox ID="TextBox1" runat="server" Width="65px">2006-1-1</asp:TextBox>
                结束日期：<asp:TextBox ID="TextBox2" runat="server" Width="64px">2008-1-1</asp:TextBox>
                图书书名：<asp:TextBox ID="TextBox3" runat="server" Width="186px"></asp:TextBox><br />
                &nbsp;图书书号：<asp:TextBox ID="TextBox4" runat="server" Width="64px"></asp:TextBox>
                图书作者：<asp:TextBox ID="TextBox5" runat="server" Width="64px"></asp:TextBox>
                图书出版公司(社)：<asp:TextBox ID="TextBox6" runat="server" Width="134px"></asp:TextBox><br />
                &nbsp;图书类别：&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True"
                    DataSourceID="SqlDataSource1" DataTextField="类别名称" DataValueField="类别名称" Width="228px">
                    <asp:ListItem>%%</asp:ListItem>
                </asp:DropDownList><asp:Button ID="Button1" runat="server" OnClick="Button1_Click"
                    Text="查询挂失图书" Width="120px" /><asp:Button ID="Button2" runat="server" OnClick="Button2_Click"
                        Text="打印挂失图书" Width="120px" /><asp:SqlDataSource ID="SqlDataSource1" runat="server"
                            ConnectionString="<%$ ConnectionStrings:MyBooksDBConnectionString %>" SelectCommand="SELECT * FROM [图书类别] ORDER BY [类别名称]">
                        </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td style="width: 2232px; height: 100px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="300px" ScrollBars="Auto" Width="553px">
                    <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#999999"
                        BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="宋体" Font-Size="Small"
                        GridLines="Vertical" Width="2154px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>