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

<!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>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSourceSQCode" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            SelectCommand="SELECT * FROM [Member] WHERE ([status] = @status) ORDER BY [id] DESC" 
            DeleteCommand="DELETE FROM [Member] WHERE [id] = @id" 
            InsertCommand="INSERT INTO [Member] ([date], [name], [mail], [IP], [status], [cookie]) VALUES (@date, @name, @mail, @IP, @status, @cookie)" 
            
            
            
            UpdateCommand="UPDATE [Member] 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="status" SessionField="status" 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>
    </div>
    </form>
</body>
</html>
