showuserinfo.aspx

一个多用户在线题库管理系统,可以实现各类试题的添加和管理

                    <td align="left">
                        <asp:TextBox ID="TQ_EmailTextBox" runat="server" Text='<%# Bind("TQ_Email") %>'></asp:TextBox>
                        <span style="color: red">*</span><asp:RequiredFieldValidator ID="RequiredFieldValidator4"
                            runat="server" ControlToValidate="TQ_EmailTextBox" ErrorMessage="必须填写"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td align="right" width="100" bgcolor="#ccccff">
                        类型：</td>
                    <td style="width: 100px" align="left" bgcolor="#ccccff">
                        <asp:DropDownList ID="ddlUserType" runat="server" Width="150px" SelectedValue='<%# Bind("TQ_UserType") %>'>
                            <asp:ListItem Value="admin">管理员</asp:ListItem>
                            <asp:ListItem Value="teacher">教师</asp:ListItem>
                            <asp:ListItem Value="student">学生</asp:ListItem>
                        </asp:DropDownList></td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                Text="插入"></asp:LinkButton>
            <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" 
                Text="取消" PostBackUrl="~/MUser.aspx"></asp:LinkButton>&nbsp;
            <asp:HyperLink ID="hlkBack" runat="server" NavigateUrl="~/MUser.aspx">返回</asp:HyperLink>
        </InsertItemTemplate>
        <ItemTemplate>
            <table>
                <tr>
                    <td style="width: 100px; height: 21px;">
                        编号：</td>
                    <td style="width: 100px; height: 21px;">
                        <asp:Label ID="TQ_UserIDLabel" runat="server" Text='<%# Eval("TQ_UserID") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px; height: 22px;">
                        登录名：</td>
                    <td style="width: 100px; height: 22px;">
                        <asp:Label ID="TQ_UserNameLabel" runat="server" Text='<%# Bind("TQ_UserName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px; height: 21px">
                        姓名：</td>
                    <td style="width: 100px; height: 21px">
                        <asp:Label ID="TQ_TureNameLabel" runat="server" Text='<%# Bind("TQ_TureName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px; height: 21px">
                        密码：</td>
                    <td style="width: 100px; height: 21px">
                        <asp:Label ID="TQ_UserPwdLabel" runat="server" Text='<%# Bind("TQ_UserPwd") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                        邮箱 ：</td>
                    <td style="width: 100px">
                        <asp:Label ID="TQ_EmailLabel" runat="server" Text='<%# Bind("TQ_Email") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                        类型：</td>
                    <td style="width: 100px">
                        <asp:Label ID="TQ_UserTypeLabel" runat="server" Text='<%# Bind("TQ_UserType") %>'></asp:Label></td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                Text="编辑"></asp:LinkButton>
            <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" OnClientClick="javascript:return confirm('你确定要删除该用户吗?');"
                Text="删除"></asp:LinkButton>
            <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
                Text="新建"></asp:LinkButton>
            <asp:HyperLink ID="hlkBack" runat="server" NavigateUrl="~/MUser.aspx">返回</asp:HyperLink>
        </ItemTemplate>
        <FooterTemplate>
            &nbsp;
        </FooterTemplate>
    </asp:FormView>
            <asp:Label ID="lblMessege" runat="server"></asp:Label></td>
        </tr>
    </table>
    &nbsp;<br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>" DeleteCommand="DELETE FROM [TQ_UserInfo] WHERE [TQ_UserID] = @original_TQ_UserID AND [TQ_UserName] = @original_TQ_UserName AND [TQ_TureName] = @original_TQ_TureName AND [TQ_UserPwd] = @original_TQ_UserPwd AND [TQ_Email] = @original_TQ_Email AND [TQ_UserType] = @original_TQ_UserType"
        InsertCommand="INSERT INTO [TQ_UserInfo] ([TQ_UserName], [TQ_TureName], [TQ_UserPwd], [TQ_Email], [TQ_UserType]) VALUES (@TQ_UserName, @TQ_TureName, @TQ_UserPwd, @TQ_Email, @TQ_UserType)"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [TQ_UserID], [TQ_UserName], [TQ_TureName], [TQ_UserPwd], [TQ_Email], [TQ_UserType] FROM [TQ_UserInfo] WHERE ([TQ_UserID] = @TQ_UserID)"
        UpdateCommand="UPDATE [TQ_UserInfo] SET [TQ_UserName] = @TQ_UserName, [TQ_TureName] = @TQ_TureName, [TQ_UserPwd] = @TQ_UserPwd, [TQ_Email] = @TQ_Email, [TQ_UserType] = @TQ_UserType WHERE [TQ_UserID] = @original_TQ_UserID AND [TQ_UserName] = @original_TQ_UserName AND [TQ_TureName] = @original_TQ_TureName AND [TQ_UserPwd] = @original_TQ_UserPwd AND [TQ_Email] = @original_TQ_Email AND [TQ_UserType] = @original_TQ_UserType">
        <DeleteParameters>
            <asp:Parameter Name="original_TQ_UserID" Type="Int32" />
            <asp:Parameter Name="original_TQ_UserName" Type="String" />
            <asp:Parameter Name="original_TQ_TureName" Type="String" />
            <asp:Parameter Name="original_TQ_UserPwd" Type="String" />
            <asp:Parameter Name="original_TQ_Email" Type="String" />
            <asp:Parameter Name="original_TQ_UserType" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="TQ_UserName" Type="String" />
            <asp:Parameter Name="TQ_TureName" Type="String" />
            <asp:Parameter Name="TQ_UserPwd" Type="String" />
            <asp:Parameter Name="TQ_Email" Type="String" />
            <asp:Parameter Name="TQ_UserType" Type="String" />
            <asp:Parameter Name="original_TQ_UserID" Type="Int32" />
            <asp:Parameter Name="original_TQ_UserName" Type="String" />
            <asp:Parameter Name="original_TQ_TureName" Type="String" />
            <asp:Parameter Name="original_TQ_UserPwd" Type="String" />
            <asp:Parameter Name="original_TQ_Email" Type="String" />
            <asp:Parameter Name="original_TQ_UserType" Type="String" />
        </UpdateParameters>
        <SelectParameters>
            <asp:QueryStringParameter DefaultValue="" Name="TQ_UserID" QueryStringField="id"
                Type="Int32" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="TQ_UserName" Type="String" />
            <asp:Parameter Name="TQ_TureName" Type="String" />
            <asp:Parameter  Name="TQ_UserPwd" Type="String" />
            <asp:Parameter Name="TQ_Email" Type="String" />
            <asp:Parameter Name="TQ_UserType" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
</asp:Content>