tcourse.aspx

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TCourse.aspx.cs" Inherits="Teacher_TCourse"  MasterPageFile="~/TQMS_Master.master"%>
<asp:Content ID ="TCourse" ContentPlaceHolderID ="main" runat="server">
    <table align="left" style="width: 555px">
        <tr>
            <td style="height: 20px;" width="80%">
                科目信息管理</td>
        </tr>
        <tr>
            <td style="height: 25px" width="80%">
                &nbsp; &nbsp; 科目：<asp:TextBox ID="tbxCourseName" runat="server" AutoCompleteType="Disabled"
                    Width="150px"></asp:TextBox>&nbsp;
                <asp:Button ID="btnSearch" runat="server" OnClick="btnSearchCourse_Click" Text="查询" Width="80px" /></td>
        </tr>
        <tr>
            <td width="80%">
                <asp:GridView ID="gvCourse" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    DataSourceID="SqlDataSource1" 
                   PageSize="5" DataKeyNames="TQ_CourseID" Width="346px">
                    <Columns>
                        <asp:BoundField DataField="TQ_CourseID" HeaderText="编号" InsertVisible="False"
                            ReadOnly="True" SortExpression="TQ_CourseID" >
                            <ItemStyle Width="50px" />
                        </asp:BoundField>
                        <asp:BoundField DataField="TQ_CourseName" HeaderText="科目名称" SortExpression="TQ_CourseName" >
                            <ItemStyle Width="200px" />
                        </asp:BoundField>
                    </Columns>
                    <EmptyDataTemplate>
                        暂无数据。
                    </EmptyDataTemplate>
                </asp:GridView>
                <asp:Label ID="lblMsg" runat="server"></asp:Label>
                <br />
                <asp:Button ID="btnShowAll" runat="server" OnClick="btnShowAll_Click" Text="显示全部" Visible="False" /><br />
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
                    SelectCommand="SELECT [TQ_CourseID], [TQ_CourseName] FROM [TQ_Courses] WHERE ([TQ_CourseName] LIKE '%' + @TQ_CourseName + '%') ORDER BY [TQ_CourseID], [TQ_CourseName]" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [TQ_Courses] WHERE [TQ_CourseID] = @original_TQ_CourseID AND [TQ_CourseName] = @original_TQ_CourseName" InsertCommand="INSERT INTO [TQ_Courses] ([TQ_CourseName]) VALUES (@TQ_CourseName)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [TQ_Courses] SET [TQ_CourseName] = @TQ_CourseName WHERE [TQ_CourseID] = @original_TQ_CourseID AND [TQ_CourseName] = @original_TQ_CourseName">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="tbxCourseName" DefaultValue="%" Name="TQ_CourseName"
                            PropertyName="Text" Type="String" />
                    </SelectParameters>
                    <DeleteParameters>
                        <asp:Parameter Name="original_TQ_CourseID" Type="Int32" />
                        <asp:Parameter Name="original_TQ_CourseName" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="TQ_CourseName" Type="String" />
                        <asp:Parameter Name="original_TQ_CourseID" Type="Int32" />
                        <asp:Parameter Name="original_TQ_CourseName" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="TQ_CourseName" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>

</asp:Content>