?<%@ Page Language="VB" MasterPageFile="~/母版1.master" AutoEventWireup="false" CodeFile="管理留言板.aspx.vb" Inherits="管理留言板" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="1" width ="100%" style="background-image: url(image/liiuyan2.jpg)">
        <tr>
            <td  colspan = 4 align =right >
                請選擇要刪除的編號:</td>
            <td style="width: 100px" colspan = 4 align =left >
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource2" DataTextField="編號" DataValueField="編號">
                </asp:DropDownList><asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
                    SelectCommand="SELECT [編號] FROM [留言板]"></asp:AccessDataSource>
            </td>
            <td style="width: 100px" colspan = 4>
                <asp:Button ID="Button1" runat="server" Text="刪除" />
                </td>
            <td style="width: 104px" colspan = 4>
                <asp:Label ID="Label1" runat="server" Text="Label" Visible="False" ForeColor="Red" Width="96px"></asp:Label></td>
        </tr>
        <tr>
            <td colspan="16">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" DataKeyNames="編號" DataSourceID="AccessDataSource3"
                    PageSize="5">
                    <Columns>
                        <asp:BoundField DataField="編號" HeaderText="編號" InsertVisible="False" ReadOnly="True"
                            SortExpression="編號" />
                        <asp:BoundField DataField="昵稱" HeaderText="昵稱" SortExpression="昵稱" />
                        <asp:BoundField DataField="內容" HeaderText="內容" SortExpression="內容" />
                        <asp:BoundField DataField="時間" HeaderText="時間" SortExpression="時間" />
                        <asp:ImageField DataImageUrlField="頭像" DataImageUrlFormatString="touxiang/{0}" HeaderText="頭像">
                        </asp:ImageField>
                    </Columns>
                </asp:GridView>
                &nbsp;
                <asp:AccessDataSource ID="AccessDataSource3" 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>
                &nbsp; &nbsp;
            </td>
        </tr>
    </table>
</asp:Content>