1<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ad_login.aspx.cs" Inherits="login" Title="后台管理" EnableSessionState="True" %>
  2<asp:Content ID="Content1"  ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  3
  4
  5    <div>
  6        <div style="text-align: center">
  7            <div style="text-align: center">
  8                <table height="100">
  9                    <tr>
 10                        <td style="width: 100px">
 11                        </td>
 12                        <td style="width: 100px">
 13                        </td>
 14                        <td style="width: 100px">
 15                        </td>
 16                    </tr>
 17                    <tr>
 18                        <td style="width: 100px">
 19                        </td>
 20                        <td style="width: 100px">
 21                        </td>
 22                        <td style="width: 100px">
 23                        </td>
 24                    </tr>
 25                    <tr>
 26                        <td style="width: 100px">
 27                        </td>
 28                        <td style="width: 100px">
 29                        </td>
 30                        <td style="width: 100px">
 31                        </td>
 32                    </tr>
 33                </table>
 34            </div>
 35            <table>
 36                <tr>
 37                    <td align="right" style="width: 226px">
 38                    </td>
 39                    <td align="right" style="width: 111px">
 40                        </td>
 41                    <td align="right" style="width: 100px">
 42                    </td>
 43                    <td align="right" style="width: 100px">
 44                    </td>
 45                    <td align="right" style="width: 100px">
 46                    </td>
 47                    <td style="width: 99px">
 48                    </td>
 49                </tr>
 50                <tr>
 51                    <td style="width: 226px" align="right">
 52                        </td>
 53                    <td align="right" style="width: 111px">
 54                    </td>
 55                    <td align="right" style="width: 100px">
 56                    </td>
 57                    <td align="right" style="width: 100px">
 58                    </td>
 59                    <td align="right" style="width: 100px">
 60                    </td>
 61                    <td style="width: 99px">
 62                        </td>
 63                </tr>
 64                <tr>
 65                    <td style="width: 226px; height: 28px;" align="right">
 66                        账号：</td>
 67                    <td align="right" style="width: 111px; height: 28px">
 68                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
 69                    <td align="right" style="width: 100px; height: 28px">
 70                        密码：</td>
 71                    <td align="right" style="width: 100px; height: 28px">
 72                        <asp:TextBox ID="TextBox2" runat="server" TextMode="Password" Width="149px"></asp:TextBox></td>
 73                    <td align="center" style="width: 100px; height: 28px">
 74                        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="登陆" />
 75                        </td>
 76                    <td style="width: 99px; height: 28px;">
 77                        </td>
 78                </tr>
 79                <tr>
 80                    <td style="width: 226px">
 81                    </td>
 82                    <td style="width: 111px">&nbsp;
 83                        </td>
 84                    <td style="width: 100px">
 85                    </td>
 86                    <td style="width: 100px">&nbsp;
 87                        </td>
 88                    <td style="width: 100px">
 89                    </td>
 90                    <td style="width: 99px">&nbsp;
 91                        </td>
 92                </tr>
 93            </table>
 94        </div>
 95    
 96    </div>
 97        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/itbm.mdb"
 98            DeleteCommand="DELETE FROM [admin] WHERE [编号] = ?" InsertCommand="INSERT INTO [admin] ([编号], [admin_name], [user_password]) VALUES (?, ?, ?)"
 99            SelectCommand="SELECT * FROM [admin] WHERE (([admin_name] = ?) AND ([user_password] = ?))"
100            UpdateCommand="UPDATE [admin] SET [admin_name] = ?, [user_password] = ? WHERE [编号] = ?">
101            <DeleteParameters>
102                <asp:Parameter Name="编号" Type="Int32" />
103            </DeleteParameters>
104            <UpdateParameters>
105                <asp:Parameter Name="admin_name" Type="String" />
106                <asp:Parameter Name="user_password" Type="String" />
107                <asp:Parameter Name="编号" Type="Int32" />
108            </UpdateParameters>
109            <SelectParameters>
110                <asp:ControlParameter ControlID="TextBox1" Name="admin_name" PropertyName="Text"
111                    Type="String" />
112                <asp:ControlParameter ControlID="TextBox2" Name="user_password" PropertyName="Text"
113                    Type="String" />
114            </SelectParameters>
115            <InsertParameters>
116                <asp:Parameter Name="编号" Type="Int32" />
117                <asp:Parameter Name="admin_name" Type="String" />
118                <asp:Parameter Name="user_password" Type="String" />
119            </InsertParameters>
120        </asp:AccessDataSource>
121        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="编号"
122            DataSourceID="AccessDataSource1" Visible="False" OnSelectedIndexChanged="Button1_Click" AllowPaging="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal" Width="80%">
123            <Columns>
124                <asp:BoundField DataField="编号" HeaderText="编号" InsertVisible="False" ReadOnly="True"
125                    SortExpression="编号" />
126                <asp:BoundField DataField="admin_name" HeaderText="用户名" SortExpression="admin_name" />
127                <asp:BoundField DataField="user_password" HeaderText="密码" SortExpression="user_password" />
128            </Columns>
129            <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
130            <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
131            <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
132            <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
133        </asp:GridView>
134        &nbsp; &nbsp; &nbsp;&nbsp;
135
136</asp:Content>
137
138
139