course_manage.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="course_manage.aspx.cs" Inherits="teacher_course_manage" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<h3>课程管理</h3>
  <asp:GridView ID="GridView3" runat="server" DataSourceID="srcGetCourse" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Crid" OnSelectedIndexChanged="GridView3_SelectedIndexChanged">
              <EmptyDataTemplate>
                现在还没有任何记录!
              </EmptyDataTemplate>
                 <Columns>
                     <asp:CommandField CausesValidation="False" HeaderText="操作" ShowDeleteButton="True"
                         ShowEditButton="True" ShowHeader="True"/>
                     <asp:BoundField DataField="Crid" HeaderText="课程编号" ReadOnly="True" SortExpression="Crid" />
                     <asp:BoundField DataField="Crname" HeaderText="课程名称" SortExpression="Crname" />
                     <asp:BoundField DataField="Crper" HeaderText="课程学时" SortExpression="Crper" />
                     <asp:BoundField DataField="Crcre" HeaderText="课程学分" SortExpression="Crcre" />
                     <asp:BoundField DataField="Crkind" HeaderText="课程类型" SortExpression="Crkind" />
                     <asp:BoundField DataField="Crelse" HeaderText="备注" SortExpression="Crelse" />
                     <asp:TemplateField HeaderText="详细信息">
                         <ItemTemplate>
                             <asp:Button ID="Button1" runat="server" CausesValidation="false" CommandName="Select" Text="详细信息"  OnClick="Button1_Click"/>
                         </ItemTemplate>
                     </asp:TemplateField>
                 </Columns>
                 <SelectedRowStyle BackColor="#FFFF80" />
             </asp:GridView>       
                <fieldset class="myfieldset1">
                <legend>添加课程信息</legend>
                <br />
                <table>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrid" runat="server" Text="课程编号：" AssociatedControlID="txtCrid" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrid" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrid" runat="server" Text="" ErrorMessage="请输入课程编号!" Display="None" ControlToValidate="txtCrid" />
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrname" runat="server" Text="课程名称：" AssociatedControlID="txtCrname" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrname" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrname" runat="server" Text="" ErrorMessage="请输入课程名称!" Display="None" ControlToValidate="txtCrname" />
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrper" runat="server" Text="课程学时：" AssociatedControlID="txtCrper" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrper" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrper" runat="server" Text="" ErrorMessage="请输入课程学时!" Display="None" ControlToValidate="txtCrper" />
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrcre" runat="server" Text="课程学分：" AssociatedControlID="txtCrcre" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrcre" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrcre" runat="server" Text="" ErrorMessage="请输入课程学分!" Display="None" ControlToValidate="txtCrcre" />
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrkind" runat="server" Text="课程类型：" AssociatedControlID="txtCrkind" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrkind" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrkind" runat="server" Text="" ErrorMessage="请输入课程类型!" Display="None" ControlToValidate="txtCrkind" />
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:Label ID="lblCrelse" runat="server" Text="备注：" AssociatedControlID="txtCrelse" />
                  </td>
                  <td>
                   <asp:TextBox ID="txtCrelse" runat="server" />
                   <asp:RequiredFieldValidator ID="reqCrelse" runat="server" Text="" ErrorMessage="请输入备注!" Display="None" ControlToValidate="txtCrelse" />
                  </td>
                 </tr>
                </table>
                <br />
                <table>
                 <tr>
                  <td class="td1" style="height: 26px">
                   <asp:Button ID="btnCOk" runat="server" Text="确定" OnClick="btnCOk_Click" />
                  </td>
                  <td style="height: 26px">
                   <asp:Button ID="btnCCancel" runat="server" Text="取消" CausesValidation="false"/>
                  </td>
                 </tr>
                </table>
                </fieldset>
                <br />
                <fieldset class="myfieldset1">
                <legend>添加任课关系</legend>
                <br />
                <table>
                 <tr align="center">
                  <th colspan="3" style="height: 20px">
                   任课关系
                  </th>
                 </tr>
                 <tr>
                  <td>
                   任课老师
                  </td>
                  <td>
                   课程名称
                  </td>
                  <td style="width: 67px">
                   持续时间
                  </td>
                 </tr>
                 <tr>
                  <td>
                   <asp:DropDownList ID="dropDownList1" runat="server" DataSourceID="srcGetData1" DataTextField="name" DataValueField="id"/>
                  </td>
                  <td>
                   <asp:DropDownList ID="dropDownList2" runat="server" DataSourceID="srcGetData2" DataTextField="Crname" DataValueField="Crid"/>
                  </td>
                  <td style="width: 67px">
                   <asp:DropDownList ID="dropDownList3" runat="server" >
                    <asp:ListItem Text="1学期" Selected="True" Value="1"/>
                    <asp:ListItem Text="2学期" Value="2"/>
                    <asp:ListItem Text="3学期" Value="3"/>
                    <asp:ListItem Text="4学期" Value="4"/>
                    <asp:ListItem Text="5学期" Value="5"/>
                    <asp:ListItem Text="6学期" Value="6"/>
                   </asp:DropDownList>
                  </td>
                 </tr>
                </table>
                <br />
                <table>
                 <tr>
                  <td class="td1">
                   <asp:Button ID="btnC_1Ok" runat="server" Text="确定" CausesValidation="false" OnClick="btnC_1Ok_Click"/>
                  </td>
                  <td>
                   <asp:Button ID="btnC_2Cancel" runat="server" Text="取消" CausesValidation="false"/>
                  </td>
                 </tr>
                </table>  
                </fieldset>             
                <asp:SqlDataSource ID="srcGetData1" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT [id], [name] FROM [tea]" />
                <asp:SqlDataSource ID="srcGetData2" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="SELECT [Crname], [Crid] FROM [tabCrous]" />
               <asp:ValidationSummary ID="validatorSum3" runat="server" ShowMessageBox="true" ShowSummary="false" />
                <div id="div1" runat="server" visible="false" class="Data3_1">
              <fieldset class="myfieldset2">
               <legend>任课老师信息</legend>
               <br />
               <asp:GridView ID="GridView3_1" runat="server" DataSourceID="srcGetDetails" AutoGenerateColumns="False" DataKeyNames="Tcid" AllowPaging="True" AllowSorting="True">
                   <Columns>
                       <asp:CommandField CausesValidation="False" HeaderText="操作" ShowDeleteButton="True"
                           ShowEditButton="True" ShowHeader="True" />
                       <asp:BoundField DataField="id" HeaderText="教师编号" ReadOnly="True" SortExpression="Tid" />
                       <asp:BoundField DataField="name" HeaderText="教师姓名"  ReadOnly="True" SortExpression="Tname" />
                       <asp:BoundField DataField="col" HeaderText="所在学院"  ReadOnly="True" SortExpression="Tcol" />
                       <asp:BoundField DataField="Cryear" HeaderText="持续时间" SortExpression="Cryear" />
                   </Columns>
                   <EmptyDataTemplate>
                    现在还没有任何记录!
                   </EmptyDataTemplate>
               </asp:GridView>
               <br />
               <table>
                <tr>
                 <td>
                  <asp:Button ID="btnC_2Ok" Text="确定" runat="server" CausesValidation="false" OnClick="btnC_2Ok_Click"/>
                 </td>
                </tr>
               </table>
               <br />
              </fieldset>
              <asp:SqlDataSource ID="srcGetDetails" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" SelectCommand="select tabtea_cour.Tcid,tabtea.Tid,tabtea.Tname,tabtea.Tcol,tabtea_cour.Cryear from tabtea,tabtea_cour where tabtea_cour.Crid=@Crid and tabtea_cour.Tid=tabtea.Tid"
               DeleteCommand="delete from tabtea_cour where tabtea_cour.Tcid=@Tcid"
               UpdateCommand="update tabtea_cour set tabtea_cour.Cryear=@Cryear where tabtea_cour.Tcid=@Tcid" >
               <SelectParameters>
                <asp:SessionParameter Name="Crid" SessionField="Selected" />
               </SelectParameters>
              </asp:SqlDataSource>
             </div>
              <asp:SqlDataSource ID="srcGetCourse" runat="server" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" DeleteCommand="DELETE FROM [tabCrous] WHERE [Crid] = @Crid" InsertCommand="INSERT INTO [tabCrous] ([Crid], [Crname], [Crper], [Crcre], [Crkind], [Crelse]) VALUES (@Crid, @Crname, @Crper, @Crcre, @Crkind, @Crelse)" SelectCommand="SELECT [Crid], [Crname], [Crper], [Crcre], [Crkind], [Crelse] FROM [tabCrous]" UpdateCommand="UPDATE [tabCrous] SET [Crname] = @Crname, [Crper] = @Crper, [Crcre] = @Crcre, [Crkind] = @Crkind, [Crelse] = @Crelse WHERE [Crid] = @Crid">
                <InsertParameters>
                    <asp:Parameter Name="Crid" Type="String" />
                    <asp:Parameter Name="Crname" Type="String" />
                    <asp:Parameter Name="Crper" Type="String" />
                    <asp:Parameter Name="Crcre" Type="String" />
                    <asp:Parameter Name="Crkind" Type="String" />
                    <asp:Parameter Name="Crelse" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
</asp:Content>