admin.aspx

来自「计算机实验课在线答疑系统 09年毕业设计」· ASPX 代码 · 共 94 行

<%@ Page Language="C#" MasterPageFile="~/admin/adminMasterPage.master" AutoEventWireup="true" CodeFile="admin.aspx.cs" Inherits="admin" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    &nbsp;<center>
       <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" 
        DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None">
        <Columns>
            <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
                SortExpression="id" />
            <asp:BoundField DataField="username" HeaderText="姓名" SortExpression="username" />
            <asp:BoundField DataField="password" HeaderText="密码" SortExpression="password" />
            <asp:CheckBoxField DataField="isadmin" HeaderText="isadmin" SortExpression="isadmin" />
            <asp:CheckBoxField DataField="isonline" HeaderText="isonline" SortExpression="isonline" />
            <asp:BoundField DataField="lastchatinfo" HeaderText="lastchatinfo" SortExpression="lastchatinfo" />
            <asp:CommandField ButtonType="Button" HeaderText="操作" ShowDeleteButton="True" ShowEditButton="True" />
        </Columns>
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <EditRowStyle BackColor="#999999" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>
        &nbsp;<br />
    </center>
    <center>
        <table>
            <tr>
                <td bgcolor="#3f558d" colspan="2" style="font-weight: bold; color: #ffffff; height: 21px">
            增加学生资料</td>
                <td bgcolor="#3f558d" style="width: 100px; height: 21px">
                </td>
            </tr>
            <tr>
                <td bgcolor="#999999" style="width: 100px">
                    姓名</td>
                <td bgcolor="#999999" style="width: 100px">
        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
                <td bgcolor="#999999" style="width: 100px">
                </td>
            </tr>
            <tr>
                <td bgcolor="#999999" style="width: 100px">
                    密码</td>
                <td bgcolor="#999999" style="width: 100px">
        <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox></td>
                <td bgcolor="#999999" style="width: 100px">
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="确定" /></td>
            </tr>
            <tr>
                <td style="width: 100px">
                </td>
                <td style="width: 100px">
                </td>
                <td style="width: 100px">
                </td>
            </tr>
        </table>
    </center>
    <center>
        &nbsp;
    </center>
    <center>
    &nbsp;    <asp:SqlDataSource  ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [UserInfo] WHERE [id] = @id" InsertCommand="INSERT INTO [UserInfo] ([username], [password], [isadmin], [isonline], [lastchatinfo]) VALUES (@username, @password, @isadmin, @isonline, @lastchatinfo)" SelectCommand="SELECT * FROM [UserInfo]" UpdateCommand="UPDATE [UserInfo] SET [username] = @username, [password] = @password, [isadmin] = @isadmin, [isonline] = @isonline, [lastchatinfo] = @lastchatinfo WHERE [id] = @id">
    
    

        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="username" Type="String" />
            <asp:Parameter Name="password" Type="String" />
            <asp:Parameter Name="isadmin" Type="Boolean" />
            <asp:Parameter Name="isonline" Type="Boolean" />
            <asp:Parameter Name="lastchatinfo" Type="Int32" />
            <asp:Parameter Name="id" Type="Int32" />
        </UpdateParameters>
        
        <InsertParameters>
            <asp:Parameter Name="username" Type="String" />
            <asp:Parameter  Name="password" Type=string />
            
           
            <asp:Parameter Name="isadmin" Type="Boolean" />
            <asp:Parameter Name="isonline" Type="Boolean" />
            <asp:Parameter Name="lastchatinfo" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    </center>
 
</asp:Content>