questiondetailbyid.aspx

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="QuestionDetailByID.aspx.cs" Inherits="ShowQuestionByID"  MasterPageFile="~/TQMS_Master.master"%>

<asp:Content ID="ShowQuestion" ContentPlaceHolderID="Main" runat="server">
    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="TQ_QuestionID"
        DataSourceID="SqlDataSource1" Height="50px" Width="80%">
        <Fields>
            <asp:BoundField DataField="TQ_QuestionID" HeaderText="编号" InsertVisible="False" ReadOnly="True"
                SortExpression="TQ_QuestionID" >
                <ItemStyle Font-Bold="True" Font-Size="12pt" ForeColor="Red" />
                <HeaderStyle HorizontalAlign="Left" Width="50px" />
            </asp:BoundField>
            <asp:BoundField DataField="TQ_QuestionContent" HeaderText="试题内容" SortExpression="TQ_QuestionContent" 
             ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="left" HeaderStyle-Width="100">
               
            </asp:BoundField>
            <asp:BoundField DataField="TQ_RightAnser"    HeaderText="正确答案" SortExpression="TQ_RightAnser"  >
             
            </asp:BoundField>
            <asp:BoundField DataField="TQ_CourseName" HeaderText="科目" SortExpression="TQ_CourseName" >
              
            </asp:BoundField>
            <asp:BoundField DataField="TQ_ImageUrl" HeaderText="图片名" SortExpression="TQ_ImageUrl" >
             
            </asp:BoundField>
            <asp:BoundField DataField="TQ_ChapterName" HeaderText="章名" SortExpression="TQ_ChapterName" >
             
            </asp:BoundField>
            <asp:BoundField DataField="TQ_UserName" HeaderText="添加人" SortExpression="TQ_UserName" >
              
            </asp:BoundField>
            <asp:BoundField DataField="TQ_Type" HeaderText="题型" SortExpression="TQ_Type" >
               
            </asp:BoundField>
            <asp:BoundField DataField="TQ_DifficultyLevel" HeaderText="难度" SortExpression="TQ_DifficultyLevel" >
               
            </asp:BoundField>
            <asp:BoundField DataField="TQ_AddTime" HeaderText="添加时间" SortExpression="TQ_AddTime" >
               
            </asp:BoundField>
            <asp:BoundField DataField="TQ_LastEditTime" HeaderText="编辑时间" SortExpression="TQ_LastEditTime" ApplyFormatInEditMode="True" DataFormatString="{0:yy-M-d}" >
              
            </asp:BoundField>
           
        </Fields>
        <HeaderStyle HorizontalAlign="Left" Width="50px" />
    </asp:DetailsView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
        SelectCommand="SELECT c.TQ_CourseName, q.TQ_ImageUrl, q.TQ_QuestionID, q.TQ_QuestionContent, q.TQ_RightAnser, p.TQ_ChapterName, u.TQ_UserName, q.TQ_Type, q.TQ_DifficultyLevel, q.TQ_AddTime, q.TQ_LastEditTime FROM TQ_Chapters AS p INNER JOIN TQ_Courses AS c ON p.TQ_CourseID = c.TQ_CourseID INNER JOIN TQ_Questions AS q ON p.TQ_ChapterID = q.TQ_ChapterID INNER JOIN TQ_UserInfo AS u ON q.TQ_UserID = u.TQ_UserID">
    </asp:SqlDataSource>
</asp:Content>