<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="admin_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>認証のページ</title>
    <style type="text/css">
        body
        {
            margin: 0;
            margin-top: 3px;
            background-image: url(../img/wallppr081.gif);
        }
        #vPage
        {
            font-size: 12pt;
            font-family: "Times New Roman";
            color: #000000;
            background-image: url(../img/wallppr082.gif);
            margin: 0 auto;
        }
        #header
        {
            text-align: center;
            background-position: top left;
            overflow: hidden; /* Div内のFloatに対応する為 */
        }
        #contents
        {
            border: 1px solid #660066;
            overflow: hidden;
        }
        #left
        {
            width: 220px;
            font-size: 12pt;
            overflow: hidden;
            margin-top: 5px;
            padding-left: 10px;
            float: left;
        }
        #main
        {
            overflow: hidden;
            margin-top: 3px;
            float: left;
            padding-left: 9px;
            padding-right: 9px;
        }
        #footer
        {
            clear: both;
            width: 100%;
            height: 50px;
            background-image: url(../img/wallppr033.gif);
            background-position: top left;
            background-repeat: repeat-x;
            overflow: hidden;
        }
        #footer h1
        {
            margin-top: 15px;
            font-size: 14pt;
        }
        /* タイトルの文字 */
        .TextboxMail
        {
            color: Red;
        }
    </style>
</head>
<body id="Backimage">
    <form id="form1" runat="server">
    <%--page▼--%>
    <div id="vPage" runat="server">
        <%--header▼--%>
        <div id="header">
            <asp:Panel ID="Panel1" runat="server" BackColor="#000099" ForeColor="#FFFF99">
                <h1 id="topTitle">
                    <asp:Label ID="Label1" runat="server" Text="認証のデータベース" Font-Bold="True" ForeColor="#FFFFCC"></asp:Label>
                    <asp:Label ID="Label10" runat="server" Text="　　データベースの閲覧と修正" Font-Size="Small"></asp:Label>
                    &nbsp;
                    <asp:Label ID="LabelName" runat="server" Text="" Font-Size="Small"></asp:Label>
                </h1>
            </asp:Panel>
        </div>
        <%--header▲--%>
        <%--Menu▼--%>
        <div id="left" runat="server">
            <asp:Panel ID="PanelPC" runat="server" Width="200px">
                <asp:Menu ID="Menu1" runat="server" BackColor="#F7F6F3" DataSourceID="SiteMapDataSourceMenu"
                    DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="Large" ForeColor="#7C6F57"
                    StaticDisplayLevels="2" StaticSubMenuIndent="30px" Width="210px">
                    <DynamicHoverStyle BackColor="#666666" ForeColor="White" />
                    <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                    <DynamicMenuStyle BackColor="#E3EAEB" />
                    <DynamicSelectedStyle BackColor="#1C5E55" />
                    <StaticHoverStyle BackColor="#666666" ForeColor="White" />
                    <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                    <StaticSelectedStyle BackColor="#DA3C41" ForeColor="White" Width="175px" />
                </asp:Menu>
                <br />
                <asp:Menu ID="Menu2" runat="server" BackColor="#F7F6F3" DataSourceID="SiteMapDataSourceMenu2"
                    DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="Large" ForeColor="#7C6F57"
                    StaticDisplayLevels="2" StaticSubMenuIndent="30px" Width="210px">
                    <DynamicHoverStyle BackColor="#666666" ForeColor="White" />
                    <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                    <DynamicMenuStyle BackColor="#E3EAEB" />
                    <DynamicSelectedStyle BackColor="#1C5E55" />
                    <StaticHoverStyle BackColor="#666666" ForeColor="White" />
                    <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                    <StaticSelectedStyle BackColor="#DA3C41" ForeColor="White" Width="175px" />
                </asp:Menu>
                <br />
                <asp:Label ID="LabelID" runat="server" Text="" Visible="False"></asp:Label>
                <asp:Label ID="LabelDayAdd" runat="server" Text="" Visible="False"></asp:Label>
                <asp:Label ID="LabelSecurity" runat="server" Text="" Visible="False"></asp:Label>
                <asp:Label ID="LabelMail" runat="server" Text="" Visible="false"></asp:Label>
                <asp:Label ID="LabelIP" runat="server" Text="" Visible="false"></asp:Label>
                <asp:Label ID="LabelCookie" runat="server" Text="" Visible="false"></asp:Label>
                <br />
                <asp:Button ID="Button2" runat="server" Text="ダウンロード" />
            </asp:Panel>
            <asp:Panel ID="PanelMobile" runat="server">
                <table style="width: 730px;">
                    <tr>
                        <td style="width: 220px;">
                            <asp:TreeView ID="TreeView1" runat="server" DataSourceID="SiteMapDataSourceMenu"
                                LineImagesFolder="~/img" ShowLines="True">
                            </asp:TreeView>
                        </td>
                        <td style="width: 30px;">
                            &nbsp;
                        </td>
                        <td>
                            <asp:Image ID="Image1" runat="server" ImageUrl="~/img/menu.png" />
                        </td>
                    </tr>
                </table>
            </asp:Panel>
            <%--            <asp:Button ID="Button5" runat="server" Text="Button" />
            <asp:Button ID="Button4" runat="server" Text="Button" /><br />
            <asp:TextBox ID="TextBoxTest" runat="server"></asp:TextBox><br />
            <asp:Label ID="Label7" runat="server" Text="Label"></asp:Label>
            --%>
        </div>
        <%--Menu▲--%>
        <%--Main▼--%>
        <div id="main">
            <asp:Panel ID="Panel3" runat="server">
                <asp:Label ID="Label4" runat="server" Text="認証を受けた会員リスト"></asp:Label>
                &nbsp;
                <asp:Label ID="Label7" runat="server" Text="id、名前、メール、IP"></asp:Label>
                <asp:TextBox ID="TextBoxName" runat="server"></asp:TextBox>
                <asp:Button ID="Button4" runat="server" Text="検索" />
                &nbsp;
                <asp:Label ID="LabelCount" runat="server" Text=""></asp:Label>
                <br />
                <asp:Label ID="LabelMsg3" runat="server" Text="" ForeColor="Red"></asp:Label>
                <div style="overflow: auto; white-space: nowrap;">
                    <asp:ListView ID="ListViewKaiin" runat="server" DataKeyNames="id" DataSourceID="SqlDataSourceMember">
                        <AlternatingItemTemplate>
                            <tr style="background-color: #FFFFFF; color: #284775;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                    <asp:Button ID="Button5" runat="server" Text="現状" CommandName="Sel" CommandArgument='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </AlternatingItemTemplate>
                        <EditItemTemplate>
                            <tr style="background-color: #999999;">
                                <td>
                                    <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="更新" />
                                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="キャンセル" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="dateTextBox" runat="server" Text='<%# Bind("date") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="mailTextBox" runat="server" Text='<%# Bind("mail") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="IPTextBox" runat="server" Text='<%# Bind("IP") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="cookieTextBox" runat="server" Text='<%# Bind("cookie") %>' />
                                </td>
                            </tr>
                        </EditItemTemplate>
                        <EmptyDataTemplate>
                            <table id="Table1" runat="server" style="background-color: #FFFFFF; border-collapse: collapse;
                                border-color: #999999; border-style: none; border-width: 1px;">
                                <tr>
                                    <td>
                                        データは返されませんでした。
                                    </td>
                                </tr>
                            </table>
                        </EmptyDataTemplate>
                        <InsertItemTemplate>
                            <tr style="">
                                <td>
                                    <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="挿入" />
                                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="クリア" />
                                </td>
                                <td>
                                    &nbsp;
                                </td>
                                <td>
                                    <asp:TextBox ID="dateTextBox" runat="server" Text='<%# Bind("date") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="mailTextBox" runat="server" Text='<%# Bind("mail") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="IPTextBox" runat="server" Text='<%# Bind("IP") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="cookieTextBox" runat="server" Text='<%# Bind("cookie") %>' />
                                </td>
                            </tr>
                        </InsertItemTemplate>
                        <ItemTemplate>
                            <tr style="background-color: #E0FFFF; color: #333333;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                    <asp:Button ID="Button3" runat="server" Text="現状" CommandName="Sel" CommandArgument='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </ItemTemplate>
                        <LayoutTemplate>
                            <table id="Table2" runat="server">
                                <tr id="Tr1" runat="server">
                                    <td id="Td1" runat="server">
                                        <table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF;
                                            border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;
                                            font-family: Verdana, Arial, Helvetica, sans-serif;">
                                            <tr id="Tr2" runat="server" style="background-color: #E0FFFF; color: #333333;">
                                                <th id="Th1" runat="server">
                                                </th>
                                                <th id="Th2" runat="server">
                                                    id
                                                </th>
                                                <th id="Th3" runat="server">
                                                    date
                                                </th>
                                                <th id="Th4" runat="server">
                                                    name
                                                </th>
                                                <th id="Th5" runat="server">
                                                    mail
                                                </th>
                                                <th id="Th6" runat="server">
                                                    IP
                                                </th>
                                                <th id="Th7" runat="server">
                                                    status
                                                </th>
                                                <th id="Th8" runat="server">
                                                    cookie
                                                </th>
                                            </tr>
                                            <tr id="itemPlaceholder" runat="server">
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr id="Tr3" runat="server">
                                    <td id="Td2" runat="server" style="text-align: center; background-color: #5D7B9D;
                                        font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF">
                                        <asp:DataPager ID="DataPager1" runat="server">
                                            <Fields>
                                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
                                            </Fields>
                                        </asp:DataPager>
                                    </td>
                                </tr>
                            </table>
                        </LayoutTemplate>
                        <SelectedItemTemplate>
                            <tr style="background-color: #E2DED6; font-weight: bold; color: #333333;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </SelectedItemTemplate>
                    </asp:ListView>
                    <asp:SqlDataSource ID="SqlDataSourceMember" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                        DeleteCommand="DELETE FROM [Member] WHERE [id] = @id" InsertCommand="INSERT INTO [Member] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)"
                        SelectCommand="SELECT * FROM [Member] ORDER BY [id] DESC" 
                        UpdateCommand="UPDATE [Member] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
                        <DeleteParameters>
                            <asp:Parameter Name="id" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="date" Type="DateTime" />
                            <asp:Parameter Name="name" Type="String" />
                            <asp:Parameter Name="mail" Type="String" />
                            <asp:Parameter Name="IP" Type="String" />
                            <asp:Parameter Name="status" Type="String" />
                            <asp:Parameter Name="cookie" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="date" Type="DateTime" />
                            <asp:Parameter Name="name" Type="String" />
                            <asp:Parameter Name="mail" Type="String" />
                            <asp:Parameter Name="IP" Type="String" />
                            <asp:Parameter Name="status" Type="String" />
                            <asp:Parameter Name="cookie" Type="String" />
                            <asp:Parameter Name="id" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </div>
                <br />
                <br />
                <asp:Label ID="Label2" runat="server" Text="幹事と運営委員リスト"></asp:Label>
                &nbsp;
                <asp:Label ID="Label3" runat="server" Text="メールを使って"></asp:Label>
                <asp:TextBox ID="TextBoxMail1" runat="server"></asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="取込" />
                <br />
                <asp:Label ID="LabelMsg" runat="server" Text="" ForeColor="Red"></asp:Label>
                <div style="overflow: auto; white-space: nowrap;">
                    <asp:ListView ID="ListViewCertify" runat="server" DataKeyNames="id" DataSourceID="SqlDataSourceAdmin">
                        <AlternatingItemTemplate>
                            <tr style="background-color: #FFFFFF; color: #284775;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </AlternatingItemTemplate>
                        <EditItemTemplate>
                            <tr style="background-color: #999999;">
                                <td>
                                    <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="更新" />
                                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="キャンセル" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="dateTextBox" runat="server" Text='<%# Bind("date") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="mailTextBox" runat="server" Text='<%# Bind("mail") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="IPTextBox" runat="server" Text='<%# Bind("IP") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="cookieTextBox" runat="server" Text='<%# Bind("cookie") %>' />
                                </td>
                            </tr>
                        </EditItemTemplate>
                        <EmptyDataTemplate>
                            <table id="Table1" runat="server" style="background-color: #FFFFFF; border-collapse: collapse;
                                border-color: #999999; border-style: none; border-width: 1px;">
                                <tr>
                                    <td>
                                        データは返されませんでした。
                                    </td>
                                </tr>
                            </table>
                        </EmptyDataTemplate>
                        <InsertItemTemplate>
                            <tr style="">
                                <td>
                                    <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="挿入" />
                                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="クリア" />
                                </td>
                                <td>
                                    &nbsp;
                                </td>
                                <td>
                                    <asp:TextBox ID="dateTextBox" runat="server" Text='<%# Bind("date") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="mailTextBox" runat="server" Text='<%# Bind("mail") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="IPTextBox" runat="server" Text='<%# Bind("IP") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
                                </td>
                                <td>
                                    <asp:TextBox ID="cookieTextBox" runat="server" Text='<%# Bind("cookie") %>' />
                                </td>
                            </tr>
                        </InsertItemTemplate>
                        <ItemTemplate>
                            <tr style="background-color: #E0FFFF; color: #333333;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </ItemTemplate>
                        <LayoutTemplate>
                            <table id="Table2" runat="server">
                                <tr id="Tr1" runat="server">
                                    <td id="Td1" runat="server">
                                        <table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF;
                                            border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;
                                            font-family: Verdana, Arial, Helvetica, sans-serif;">
                                            <tr id="Tr2" runat="server" style="background-color: #E0FFFF; color: #333333;">
                                                <th id="Th1" runat="server">
                                                </th>
                                                <th id="Th2" runat="server">
                                                    id
                                                </th>
                                                <th id="Th3" runat="server">
                                                    date
                                                </th>
                                                <th id="Th4" runat="server">
                                                    name
                                                </th>
                                                <th id="Th5" runat="server">
                                                    mail
                                                </th>
                                                <th id="Th6" runat="server">
                                                    IP
                                                </th>
                                                <th id="Th7" runat="server">
                                                    status
                                                </th>
                                                <th id="Th8" runat="server">
                                                    cookie
                                                </th>
                                            </tr>
                                            <tr id="itemPlaceholder" runat="server">
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr id="Tr3" runat="server">
                                    <td id="Td2" runat="server" style="text-align: center; background-color: #5D7B9D;
                                        font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF">
                                        <asp:DataPager ID="DataPager1" runat="server">
                                            <Fields>
                                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
                                            </Fields>
                                        </asp:DataPager>
                                    </td>
                                </tr>
                            </table>
                        </LayoutTemplate>
                        <SelectedItemTemplate>
                            <tr style="background-color: #E2DED6; font-weight: bold; color: #333333;">
                                <td>
                                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="削除" />
                                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編集" />
                                </td>
                                <td>
                                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="dateLabel" runat="server" Text='<%# Eval("date") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="mailLabel" runat="server" Text='<%# Eval("mail") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="IPLabel" runat="server" Text='<%# Eval("IP") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
                                </td>
                                <td>
                                    <asp:Label ID="cookieLabel" runat="server" Text='<%# Eval("cookie") %>' />
                                </td>
                            </tr>
                        </SelectedItemTemplate>
                    </asp:ListView>
                    <asp:SqlDataSource ID="SqlDataSourceAdmin" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                        DeleteCommand="DELETE FROM [Admin] WHERE [id] = @id" InsertCommand="INSERT INTO [Admin] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)"
                        SelectCommand="SELECT * FROM [Admin] ORDER BY [id] DESC" 
                        UpdateCommand="UPDATE [Admin] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
                        <DeleteParameters>
                            <asp:Parameter Name="id" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="date" Type="DateTime" />
                            <asp:Parameter Name="name" Type="String" />
                            <asp:Parameter Name="mail" Type="String" />
                            <asp:Parameter Name="IP" Type="String" />
                            <asp:Parameter Name="status" Type="String" />
                            <asp:Parameter Name="cookie" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="date" Type="DateTime" />
                            <asp:Parameter Name="name" Type="String" />
                            <asp:Parameter Name="mail" Type="String" />
                            <asp:Parameter Name="IP" Type="String" />
                            <asp:Parameter Name="status" Type="String" />
                            <asp:Parameter Name="cookie" Type="String" />
                            <asp:Parameter Name="id" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </div>
            </asp:Panel>
        </div>
        <%--Main▲--%>
        <%--Footer▼--%>
        <div id="footer">
            <asp:Panel ID="Panel4" runat="server">
                <hr />
                &nbsp;&nbsp;&nbsp;
                <asp:Label ID="LabelFooter" runat="server" Text="Footer"></asp:Label>
                <br />
            </asp:Panel>
        </div>
        <%--Footer▲--%>
    </div>
    <%--page▲--%>
    <asp:SqlDataSource ID="SqlDataSourceAdminByCookie" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        
        SelectCommand="SELECT * FROM [Admin] WHERE ([cookie] = @cookie) ORDER BY [id] DESC" 
        DeleteCommand="DELETE FROM [Admin] WHERE [id] = @id" 
        InsertCommand="INSERT INTO [Admin] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)" 
        UpdateCommand="UPDATE [Admin] SET [date] = @date, [name] = @name, [mail] = @mail, [IP] = @IP, [status] = @status, [cookie] = @cookie WHERE [id] = @id">
        <DeleteParameters>
            <asp:SessionParameter Name="id" SessionField="id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
            <asp:SessionParameter Name="name" SessionField="name" Type="String" />
            <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
            <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
            <asp:SessionParameter Name="status" SessionField="status" Type="String" />
            <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
        </InsertParameters>
        <SelectParameters>
            <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
        </SelectParameters>
        <UpdateParameters>
            <asp:SessionParameter Name="date" SessionField="date" Type="DateTime" />
            <asp:SessionParameter Name="name" SessionField="name" Type="String" />
            <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
            <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
            <asp:SessionParameter Name="status" SessionField="status" Type="String" />
            <asp:SessionParameter Name="cookie" SessionField="cookie" Type="String" />
            <asp:SessionParameter Name="id" SessionField="id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSourceMemberByid" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [Member] WHERE ([id] = @id)">
        <SelectParameters>
            <asp:SessionParameter Name="id" SessionField="id" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSourceMemberByIP" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        
        SelectCommand="SELECT * FROM [Member] WHERE ([IP] = @IP) ORDER BY [id] DESC">
        <SelectParameters>
            <asp:SessionParameter Name="IP" SessionField="IP" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSourceMemberByMail" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        
        SelectCommand="SELECT * FROM [Member] WHERE ([mail] = @mail) ORDER BY [id] DESC">
        <SelectParameters>
            <asp:SessionParameter Name="mail" SessionField="mail" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSourceMemberByName" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        
        SelectCommand="SELECT * FROM [Member] WHERE ([name] = @name) ORDER BY [id] DESC">
        <SelectParameters>
            <asp:SessionParameter Name="name" SessionField="name" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <%--<ajaxToolkit:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server"
        TargetControlID="TextBoxMail" WatermarkText="メールアドレス" WatermarkCssClass="TextboxMail" />--%>
    <asp:SiteMapDataSource ID="SiteMapDataSourceMenu" runat="server" SiteMapProvider="forViewer" />
    <asp:SiteMapDataSource ID="SiteMapDataSourceMenu2" runat="server" SiteMapProvider="forWriter" />
    </form>
</body>
</html>
