cour_choose.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="cour_choose.aspx.cs" Inherits="stu_cour_choose" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<center>
          <br />
          <h3>选课操作</h3>
          以下是您可以选择的课程，最多可以选择3门课，单击“确定”提交信息。
          <br />
          <br />
          <table border="1">
            <tr>
             <td>
              <asp:CheckBoxList ID="checkBoxSelectCourse" runat="server" RepeatColumns="5" DataSourceID="srcGetCourse" RepeatDirection="Horizontal" DataTextField="Crname" DataValueField="Crid" />
             </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="取消" OnClick="btnCalcelSubmit_Click" />
            </td>
           </tr>
          </table>
         </center>
         <asp:SqlDataSource ID="srcGetCourse" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT tabCrous.[Crid], tabCrous.[Crname] FROM [tabCrous], tabstu_cour where tabCrous.Crid not in 
(select tabstu_cour.Crid from tabstu_cour where tabstu_Cour.sid=@Sid)
group by tabCrous.[Crid], tabCrous.[Crname]" DataSourceMode="DataReader">
          <SelectParameters>
           <asp:SessionParameter Name="Sid" SessionField="UserID" />
          </SelectParameters>
         </asp:SqlDataSource>
</asp:Content>