mark.aspx

asp.net 学生信息管理系统！可以作为课程设计来使用

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="mark.aspx.cs" Inherits="teacher_mark" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  <div>
            <center>
             <br />
             <h1>成绩管理</h1>
             您可以按课程名称来查询学生分数：
             <br />
             <asp:DropDownList ID="dropDownListSelectCrid" runat="server" DataSourceID="srcGetSelectCrid" DataTextField="Crname" DataValueField="Crid" />
             <asp:Button ID="btnSelect" runat="server" Text="查询" CausesValidation="False" OnClick="btnSelect_Click" />
             <asp:GridView ID="GridView5" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="srcGetScore" DataKeyNames="Scid">
              <EmptyDataTemplate>
               现在还没有任何数据!
              </EmptyDataTemplate>
                 <Columns>
                     <asp:CommandField HeaderText="操作" ShowDeleteButton="True" ShowEditButton="True" ShowHeader="True" />
                     <asp:BoundField DataField="Crid" HeaderText="课程编号" ReadOnly="True" SortExpression="Crid" />
                      <asp:BoundField DataField="Crname" HeaderText="课程名称" ReadOnly="True" SortExpression="Crname" />
                     <asp:BoundField DataField="id" HeaderText="学生编号" ReadOnly="True" SortExpression="id" />
                     <asp:BoundField DataField="stu_name" HeaderText="学生姓名" ReadOnly="True" SortExpression="stu_name" />
                     <asp:BoundField DataField="Score" HeaderText="成绩" SortExpression="Score" />                   
                     <asp:BoundField DataField="Scid" HeaderText="编号" SortExpression="Scid" ReadOnly="True" Visible="False"/>  
                 </Columns>
             </asp:GridView>
             <div id="Data5" >
              <fieldset class="myfieldset">
               <legend>添加学生成绩</legend>
               <br />
               <table>
                <tr>
                 <td>
                  <asp:Label ID="lbldropDownListName" Text="学生姓名：" runat="server" AssociatedControlID="dropDownListName" />
                 </td>
                 <td align="left">
                  <asp:DropDownList ID="dropDownListName" runat="server" DataSourceID="srcGetName" DataTextField="stu_name" DataValueField="stu_name" />
                 </td>
                </tr>
                <tr>
                 <td>
                  <asp:Label ID="lblSelectCourse" runat="server" Text="所选课程：" AssociatedControlID="dropDownListSelectCourse" />
                 </td>
                 <td align="left">
                  <asp:DropDownList ID="dropDownListSelectCourse" runat="server" DataSourceID="srcGetSelectCourse" DataTextField="Crname" DataValueField="Crid" />
                 </td>
                </tr>
                <tr>
                 <td>
                  <asp:Label ID="lblScore" runat="server" Text="成绩：" AssociatedControlID="txtScore" />
                 </td>
                 <td>
                  <asp:TextBox ID="txtScore" runat="server" />
                  <asp:RequiredFieldValidator ID="reqScore" Text="" ErrorMessage="请输入学生成绩!" Display="None" runat="server" ControlToValidate="txtScore" />
                 </td>
                </tr>
               </table>
               <br />
               <table>
                <tr>
                 <td class="td1">
                  <asp:Button ID="btnSubmit" runat="server" Text="确定" OnClick="btnSubmit_Click" />
                 </td>
                 <td class="td1">
                  <asp:Button ID="btnCalcelSubmit" runat="server" Text="取消" CausesValidation="false"/>
                 </td>
                </tr>
               </table>
               <asp:ValidationSummary ID="validatorSum4" runat="server" ShowMessageBox="true" ShowSummary="false" />
              </fieldset>
             </div>
            </center>
            <asp:SqlDataSource ID="srcGetName" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT [id], [stu_name] FROM [stu]" />
            <asp:SqlDataSource ID="srcGetSelectCourse" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT [Crid], [Crname] FROM [tabCrous]" />
            <asp:SqlDataSource ID="srcGetScore" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" 
            SelectCommand="SELECT tabCrous.Crname, stu.stu_name, tabstu_cour.Sid, tabstu_cour.Crid, tabstu_cour.Score, tabstu_cour.Scid FROM tabstu_cour INNER JOIN stu ON tabstu_cour.Sid = stu.id INNER JOIN tabCrous ON tabstu_cour.Crid = tabCrous.Crid WHERE (tabstu_cour.Crid = @Crid)" 
            DeleteCommand="DELETE FROM [tabstu_cour] WHERE [Scid] = @Scid" 
            InsertCommand="INSERT INTO [tabstu_cour] ([Score], [Sid], [Crid]) VALUES (@Score, @Sid, @Crid)" 
            UpdateCommand="UPDATE [tabstu_cour] SET [Score] = @Score WHERE [Scid] = @Scid" >
                <SelectParameters>
                 <asp:ControlParameter Name="Crid" ControlID="dropDownListSelectCrid" PropertyName="SelectedValue" />
                </SelectParameters>
                <DeleteParameters>
                    <asp:Parameter Name="Scid" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Score" Type="String" />
                    <asp:Parameter Name="Scid" Type="Int32" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="Score" Type="String" />
                    <asp:Parameter Name="Sid" Type="String" />
                    <asp:Parameter Name="Crid" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
            <asp:SqlDataSource ID="srcGetSelectCrid" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT [Crid], [Crname] FROM [tabCrous]" />
           </div>
</asp:Content>