tea_manage.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="tea_manage.aspx.cs" Inherits="teacher_tea_manage" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <center>
 <h3>教师管理</h3>
 <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="srcGetTeacher" DataKeyNames="id">
                 <Columns>
                     <asp:CommandField HeaderText="操作" ShowDeleteButton="True" ShowEditButton="True" ShowHeader="True" CausesValidation="False" />
                     <asp:BoundField DataField="id" HeaderText="教师编号" ReadOnly="True" SortExpression="id" />
                     <asp:BoundField DataField="name" HeaderText="教师姓名" SortExpression="name" />
                     <asp:BoundField DataField="lev" HeaderText="职称" SortExpression="lev" />
                 </Columns>
                 <EmptyDataTemplate>
                    现在还没有任何记录!
                 </EmptyDataTemplate>
             </asp:GridView>
             <div id="Data2">
              <fieldset class="myfieldset">
               <legend>添加教师信息</legend>
               <br />
               <table>
                <tr>
                 <td>
                  <asp:Label ID="lblTid" runat="server" Text="教师编号：" AssociatedControlID="txtTid" />
                 </td>
                 <td>
                  <asp:TextBox ID="txtTid" runat="server" />
                  <asp:RequiredFieldValidator ID="reqTid" runat="server" Text="" ErrorMessage="请输入教师编号!" ControlToValidate="txtTid" Display="None" />
                 </td>
                </tr>
                <tr>
                 <td>
                  <asp:Label ID="lblTname" runat="server" Text="教师姓名：" AssociatedControlID="txtTname" />
                 </td>
                 <td>
                  <asp:TextBox ID="txtTname" runat="server" />
                  <asp:RequiredFieldValidator ID="reqTname" runat="server" Text="" ErrorMessage="请输入教师姓名!" ControlToValidate="txtTname" Display="None" /> 
                 </td>
                </tr>
                <tr>
                 <td>
                  <asp:Label ID="lblTcol" runat="server" Text="所在学院：" AssociatedControlID="txtTcol" />     
                 </td>
                 <td>
                  <asp:TextBox ID="txtTcol" runat="server" />
                  <asp:RequiredFieldValidator ID="reqTcol" Text="" ErrorMessage="请输入所在学院!" Display="None" ControlToValidate="txtTcol" runat="server" />
                 </td>
                </tr>
               </table>
               <br />
               <table>
                <tr>
                 <td class="td1">
                  <asp:Button ID="btnTOk" runat="server" Text="确定" OnClick="btnTOk_Click" />
                 </td>
                 <td class="td1">
                  <asp:Button ID="btnTCancel" runat="server" Text="取消" CausesValidation="false"/>
                 </td>
                </tr>
               </table>
               <asp:ValidationSummary ID="validatorSum2" ShowMessageBox="true" ShowSummary="false" runat="server" />
              </fieldset>
             </div>
            </center>
            <asp:SqlDataSource ID="srcGetTeacher" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" runat="server" InsertCommand="INSERT INTO [tea] ([id], [name], [lev]) VALUES (@id, @name, @lev)" SelectCommand="SELECT [id], [name], [lev] FROM [tea]" >
                <InsertParameters>
                    <asp:Parameter Name="id" Type="String" />
                    <asp:Parameter Name="name" Type="String" />
                    <asp:Parameter Name="lev" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
             <fieldset class="myfieldset1">
                <legend>添加任课关系</legend>
                <br />
                <table>
                 <tr align="center">
                  <th colspan="3" style="height: 20px">
                   任课关系
                  </th>
                 </tr>
                 <tr>
                  <td>
                   任课老师
                  </td>
                  <td>
                   课程名称
                  </td>
                  <td>
                   持续时间
                  </td>
                 </tr>
                 <tr>
                  <td style="height: 24px">
                   <asp:DropDownList ID="dropDownList1" runat="server" DataSourceID="srcGetData1" DataTextField="name" DataValueField="name"/>
                  </td>
                  <td style="height: 24px">
                   <asp:DropDownList ID="dropDownList2" runat="server" DataSourceID="srcGetData2" DataTextField="Crname" DataValueField="Crid"/>
                  </td>
                  <td style="height: 24px">
                   <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="id" />
                       <asp:BoundField DataField="name" HeaderText="教师姓名"  ReadOnly="True" SortExpression="name" />
                       <asp:BoundField DataField="lev" HeaderText="所在学院"  ReadOnly="True" SortExpression="lev" />
                       <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">
                <DeleteParameters>
                    <asp:Parameter Name="Crid" Type="String" />
                </DeleteParameters>
                <UpdateParameters>
                    <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" />
                    <asp:Parameter Name="Crid" Type="String" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:ControlParameter Name="Crid" ControlID="txtCrid" />
                    <asp:ControlParameter Name="Crname" ControlID="txtCrname" />
                    <asp:ControlParameter Name="Crper" ControlID="txtCrper" />
                    <asp:ControlParameter Name="Crcre" ControlID="txtCrcre" />
                    <asp:ControlParameter Name="Crkind" ControlID="txtCrkind" />
                    <asp:ControlParameter Name="Crelse" ControlID="txtCrelse" />
                </InsertParameters>
            </asp:SqlDataSource>
     
</asp:Content>