meditchapter.aspx

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MEditChapter.aspx.cs" Inherits="Manager_MEditChapter" MasterPageFile="~/TQMS_Master.master" %>
<asp:Content ID="ContentChapter" ContentPlaceHolderID="main" runat="server">
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="TQ_ChapterID" DataSourceID="SqlDataSource1"
        DefaultMode="Edit" OnItemInserted="FormView1_ItemInserted" Width="80%">
        <EditItemTemplate>
            <table style="width: 500px" border="0" cellpadding="0" cellspacing="0">
                 <tr>
                     <td colspan="2" style="color: white; font-weight: bold; font-size: 12pt; height: 30px;" bgcolor="#9999ff" height="30">
                         &nbsp;<strong>章目信息的修改</strong></td>
                </tr>
                 <tr>
                     <td colspan="2" style="height: 22px">
                         &nbsp;请<span style="color: red">注意</span>：<span style="font-size: 10pt">标准格式为：第一章 计算机基础</span></td>
                </tr>
                <tr>
                    <td align="left" bgcolor="#ccccff">
                        章编号：</td>
                    <td align="left" bgcolor="#ccccff">
                        <asp:Label ID="TQ_ChapterIDLabel1" runat="server" Text='<%# Eval("TQ_ChapterID") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td align="left">
                        章目名称：</td>
                    <td align="left">
                        <asp:TextBox ID="TQ_ChapterNameTextBox" runat="server" Text='<%# Bind("TQ_ChapterName") %>'></asp:TextBox><span
                            style="font-size: 10pt">最多３０个字符</span></td>
                </tr>
                <tr>
                    <td align="left" style="height: 25px" bgcolor="#ccccff">
                        所属科目：</td>
                    <td style="height: 25px" align="left" bgcolor="#ccccff">
                        <asp:DropDownList ID="ddlCourse" runat="server" DataSourceID="SqlDataSource2"
                            DataTextField="TQ_CourseName" DataValueField="TQ_CourseID" SelectedValue='<%# Bind("TQ_CourseID") %>'
                            Width="261px">
                        </asp:DropDownList>
                    </td>
                </tr>
                <tr>
                    <td align="left" style="width: 56px">
                    </td>
                    <td style="width: 100px" align="left">
                    </td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="更新"></asp:LinkButton>&nbsp;
                <asp:HyperLink ID="hlkBack" runat="server" NavigateUrl="~/MChapterAndSection.aspx">返回</asp:HyperLink>
        </EditItemTemplate>
        <InsertItemTemplate>
            <table style="width: 100%">
                <tr>
                    <td colspan="2">
                        试题管理---添加科目</td>
                </tr>
                <tr>
                    <td>
                        章目名称：</td>
                    <td>
                        <asp:TextBox ID="tbxChapterName" runat="server" Text='<%# Bind("TQ_ChapterName") %>'
                            Width="198px"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="tbxChapterName"
                            ErrorMessage="必须填写"></asp:RequiredFieldValidator>(30字符以内)</td>
                </tr>
                <tr>
                    <td>
                        所属科目：</td>
                    <td>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                            DataTextField="TQ_CourseName" DataValueField="TQ_CourseID" SelectedValue='<%# Bind("TQ_CourseID") %>'
                            Width="205px">
                        </asp:DropDownList></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                    </td>
                    <td style="width: 295px">
                    </td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 20px">
                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="insert">插入</asp:LinkButton>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/MChapterAndSection.aspx">返回</asp:HyperLink></td>
                </tr>
            </table>
        </InsertItemTemplate>
       
    </asp:FormView>
    &nbsp; &nbsp;&nbsp;&nbsp;
    <asp:Label ID="lblMessege" runat="server" Width="105px"></asp:Label>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
       
        SelectCommand="SELECT [TQ_ChapterID], [TQ_ChapterName], [TQ_CourseID] FROM [TQ_Chapters] WHERE ([TQ_ChapterID] = @TQ_ChapterID)"
        UpdateCommand="UPDATE [TQ_Chapters] SET [TQ_ChapterName] = @TQ_ChapterName, [TQ_CourseID] = @TQ_CourseID WHERE [TQ_ChapterID] = @TQ_ChapterID" DeleteCommand="DELETE FROM [TQ_Chapters] WHERE [TQ_ChapterID] = @TQ_ChapterID" InsertCommand="INSERT INTO [TQ_Chapters] ([TQ_ChapterName], [TQ_CourseID]) VALUES (@TQ_ChapterName, @TQ_CourseID)">
        <SelectParameters>
            <asp:QueryStringParameter Name="TQ_ChapterID" QueryStringField="id" Type="Int32" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="TQ_ChapterName" Type="String" />
            <asp:Parameter Name="TQ_CourseID" Type="Int32" />
            <asp:Parameter Name="TQ_ChapterID" Type="Int32" />
             
        </UpdateParameters>
        <DeleteParameters>
            <asp:Parameter Name="TQ_ChapterID" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="TQ_ChapterName" Type="String" />
            <asp:Parameter Name="TQ_CourseID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
        SelectCommand="SELECT [TQ_CourseID], [TQ_CourseName] FROM [TQ_Courses]"></asp:SqlDataSource>
</asp:Content>