score.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="score.aspx.cs" Inherits="stu_score" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<h3>成绩查询</h3>
          下面是你所选各个课程的成绩：
          <br />
          <br />
          <asp:GridView ID="GridView2" runat="server" DataSourceID="srcGetScore" AutoGenerateColumns="False">
           <EmptyDataTemplate>
            现在还没有录入任何成绩，请耐心等待!
           </EmptyDataTemplate>
              <Columns>
                  <asp:BoundField DataField="stu_name" HeaderText="学生姓名" ReadOnly="True" SortExpression="sname" />
                  <asp:BoundField DataField="Crname" HeaderText="课程名称" ReadOnly="True" SortExpression="Crname" />
                  <asp:BoundField DataField="Score" HeaderText="课程成绩" ReadOnly="True" SortExpression="Score" />
              </Columns>
          </asp:GridView>
          <asp:SqlDataSource ID="srcGetScore" runat="server" DataSourceMode="DataReader" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="select stu.stu_name,tabCrous.Crname,tabstu_cour.Score from stu,tabCrous,tabstu_cour where tabstu_cour.Sid=@Sid and tabstu_cour.Sid=stu.id and tabstu_cour.Crid=tabCrous.Crid" >
           <SelectParameters>
            <asp:SessionParameter Name="Sid" SessionField="UserID" />
           </SelectParameters>
          </asp:SqlDataSource>
      
</asp:Content>