adminusersadd.aspx

来自「本程序基于 asp.net 2.0 +sql server 2」· ASPX 代码 · 共 52 行

ASPX
52
字号
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="adminUsersAdd.aspx.cs" Inherits="admin_adminUsersAdd" %>

<!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>
            <div class ="left"><!-- #include file ="adminleft.htm" --></div>
    <div class ="center">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="adminid"
            DataSourceID="SqlDataSource1">
            <Columns>
                <asp:CommandField ShowDeleteButton="True" />
                <asp:BoundField DataField="username" HeaderText="username" SortExpression="username" />
                <asp:BoundField DataField="loginip" HeaderText="loginip" SortExpression="loginip" />
                <asp:BoundField DataField="logintime" HeaderText="logintime" SortExpression="logintime" />
                <asp:BoundField DataField="adminid" HeaderText="adminid" InsertVisible="False" ReadOnly="True"
                    SortExpression="adminid" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dsn %>"
            DeleteCommand="DELETE FROM [admin_user] WHERE [adminid] = @adminid" InsertCommand="INSERT INTO [admin_user] ([username], [loginip], [logintime]) VALUES (@username, @loginip, @logintime)"
            SelectCommand="SELECT [username], [loginip], [logintime], [adminid] FROM [admin_user]"
            UpdateCommand="UPDATE [admin_user] SET [username] = @username, [loginip] = @loginip, [logintime] = @logintime WHERE [adminid] = @adminid">
            <DeleteParameters>
                <asp:Parameter Name="adminid" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="username" Type="String" />
                <asp:Parameter Name="loginip" Type="String" />
                <asp:Parameter Name="logintime" Type="DateTime" />
                <asp:Parameter Name="adminid" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="username" Type="String" />
                <asp:Parameter Name="loginip" Type="String" />
                <asp:Parameter Name="logintime" Type="DateTime" />
            </InsertParameters>
        </asp:SqlDataSource>
        <br />
        管理员帐号:<asp:TextBox ID="tb_username" runat="server" Width="150px"></asp:TextBox><br />
        管理员密码:<asp:TextBox ID="tb_password" runat="server" TextMode="Password" Width="150px"></asp:TextBox><br />
        <asp:Button ID="btnAdd" runat="server" Text="添加" OnClick="btnAdd_Click" /></div>
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?