cour_infor.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="cour_infor.aspx.cs" Inherits="stu_cour_choose" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  <h1>选课信息</h1>
          您所选课程的详细信息如下:
          <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="srcGetCrous">
           <EmptyDataTemplate>
            您还没有选择任何课程!
           </EmptyDataTemplate>
              <Columns>
                  <asp:BoundField DataField="Crname" HeaderText="课程名称" ReadOnly="True" SortExpression="Crname" />
                  <asp:BoundField DataField="Crper" HeaderText="课程学时" ReadOnly="True" SortExpression="Crper" />
                  <asp:BoundField DataField="Crcre" HeaderText="课程学分" ReadOnly="True" SortExpression="Crcre" />
                  <asp:BoundField DataField="name" HeaderText="教师姓名" ReadOnly="True" SortExpression="name" />
              </Columns>
          </asp:GridView>
          <asp:SqlDataSource ID="srcGetCrous" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>"
           SelectCommand="select tabCrous.Crname,tabCrous.Crper,tabCrous.Crcre,tea.name from tabCrous,tea,stu,tabstu_cour,tabtea_cour where tabstu_cour.sid=@Sid and tabstu_cour.crid=tabCrous.crid and tabtea_cour.Tid=tea.id and tabstu_cour.crid=tabtea_cour.crid group by tabCrous.Crname,tabCrous.Crper,tabCrous.Crcre,tea.name" DataSourceMode="DataReader">
            <SelectParameters>
             <asp:SessionParameter Name="Sid" SessionField="UserID" />
            </SelectParameters>
           </asp:SqlDataSource>
        
         
</asp:Content>