tuser.aspx

一个试题库设计

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TUser.aspx.cs" Inherits="Teacher_TUser"  MasterPageFile="~/TQMS_Master.master"%>
<asp:Content ID="TUser" ContentPlaceHolderID="main" runat="server">
    &nbsp;<table width="100%">
        <tr>
            <td align="center" width="10">
                &nbsp;</td>
            <td>
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="TQ_UserID" DataSourceID="SqlDataSource1" Width="350px">
        <EditItemTemplate>
            <table class="table" width="400">
                <tr>
                    <td class="tdHead" colspan="2" style="height: 21px">
                        <p class="MsoNormal" style="margin: 0cm 0cm 0pt; tab-stops: list 0cm">
                            <span style="font-size: 10pt; font-family: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: 'Times New Roman';
                                mso-hansi-font-family: 'Times New Roman'"><b style="mso-bidi-font-weight: normal">
                                </b><span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: 'Times New Roman';
                                    mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman';
                                    mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">
                                    修改</span>个人信息</span></p>
                    </td>
                </tr>
                <tr style="font-size: 12pt">
                    <td colspan="2" style="height: 21px">
            <asp:Label ID="TQ_UserIDLabel1" runat="server" Text='<%# Eval("TQ_UserID") %>'></asp:Label></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td class="tdAlter" align="left" width="120">
                        用户名：</td>
                    <td style="width: 100px; height: 21px" align="left" class="tdAlter">
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("TQ_UserName") %>'></asp:Label></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td align="left" width="120">
                        姓 名：</td>
                    <td style="width: 100px" align="left">
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("TQ_TureName") %>'></asp:Label></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td class="tdAlter" align="left" width="120">
                        密 码：</td>
                    <td style="width: 100px; height: 24px" align="left" class="tdAlter">
            <asp:TextBox ID="TQ_UserPwdTextBox" runat="server" Text='<%# Bind("TQ_UserPwd") %>' TextMode="Password"></asp:TextBox></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td style="height: 24px" align="left" width="120">
                        <span style="font-family: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';
                            mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US;
                            mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; font-size: 11pt;">再次输入密码：</span></td>
                    <td align="left" style="width: 100px; height: 24px">
                        <asp:TextBox ID="TextBox1" runat="server" TextMode="Password"></asp:TextBox>
                        <asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="TQ_UserPwdTextBox"
                            ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage=" 两次密码不同"></asp:CompareValidator></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td class="tdAlter" align="left" width="120">
                        邮 箱：</td>
                    <td style="width: 100px" align="left" class="tdAlter">
            <asp:TextBox ID="TQ_EmailTextBox" runat="server" Text='<%# Bind("TQ_Email") %>'>
            </asp:TextBox></td>
                </tr>
                <tr style="font-size: 12pt">
                    <td align="left" width="120">
                        用户类型：</td>
                    <td style="width: 100px" align="left">
                        <asp:Label ID="TQ_UserTypeLabel" runat="server" Text='<%# Bind("TQ_UserType") %>'></asp:Label></td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="更新">
            </asp:LinkButton>
            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                Text="取消">
            </asp:LinkButton>
        </EditItemTemplate>
     
        <ItemTemplate>
            <table class="table">
                <tr>
                    <td class="tdHead" colspan="2" style="height: 21px">
                        <p class="MsoNormal" style="margin: 0cm 0cm 0pt; tab-stops: list 0cm">
                            <b style="mso-bidi-font-weight: normal"><span style="font-size: 10pt; font-family: 宋体;
                                mso-bidi-font-size: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">
                                个人信息</span></b><b style="mso-bidi-font-weight: normal"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt"><?xml
                                    namespace="" ns="urn:schemas-microsoft-com:office:office" prefix="o" ?><?xml namespace=""
                                        prefix="o" ?><o:p></o:p></span></b></p>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 21px">
            <asp:Label ID="TQ_UserIDLabel" runat="server" Text='<%# Eval("TQ_UserID") %>' Visible="False"></asp:Label></td>
                </tr>
                <tr>
                    <td style="height: 21px" class="tdAlter" width="100">
                        用户名：</td>
                    <td style="width: 100px; height: 21px" class="tdAlter">
            <asp:Label ID="TQ_UserNameLabel" runat="server" Text='<%# Bind("TQ_UserName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td width="100">
                        姓 名：</td>
                    <td style="width: 100px">
            <asp:Label ID="TQ_TureNameLabel" runat="server" Text='<%# Bind("TQ_TureName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td class="tdAlter" width="100">
                        密 码：</td>
                    <td style="width: 100px" class="tdAlter">
            <asp:Label ID="TQ_UserPwdLabel" runat="server" Text='<%# Bind("TQ_UserPwd") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td width="100">
                        邮 箱：</td>
                    <td style="width: 100px">
            <asp:Label ID="TQ_EmailLabel" runat="server" Text='<%# Bind("TQ_Email") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td class="tdAlter" width="100">
                        用户类型：</td>
                    <td style="width: 100px" class="tdAlter">
                        <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>
            &nbsp;
        </ItemTemplate>
    </asp:FormView>
            </td>
        </tr>
    </table>
    &nbsp;
    <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"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [TQ_UserID], [TQ_UserName], [TQ_TureName], [TQ_UserPwd], [TQ_Email], [TQ_UserType] FROM [TQ_UserInfo] WHERE ([TQ_TureName] = @TQ_TureName)"
        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:SessionParameter Name="TQ_TureName" SessionField="UserName" Type="String" />
        </SelectParameters>
       
    </asp:SqlDataSource>
</asp:Content>