stu_manage.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="stu_manage.aspx.cs" Inherits="teacher_stu_manage" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<h3>学生管理</h3>
              <br />
               <asp:GridView ID="GridView1" runat="server" DataSourceID="srcGetStudent" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="id" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" PageSize="8" >
                   <Columns>
                       <asp:CommandField HeaderText="操作" ShowDeleteButton="True" ShowEditButton="True" ShowHeader="True" CausesValidation="False" />
                       <asp:BoundField DataField="id" HeaderText="学号" ReadOnly="True" SortExpression="id" />
                       <asp:BoundField DataField="stu_name" HeaderText="姓名" SortExpression="stu_name" />
                       <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                       <asp:BoundField DataField="nati" HeaderText="民族" SortExpression="nati" />
                       <asp:BoundField DataField="bir" HeaderText="出生日期" SortExpression="bir" />
                       <asp:BoundField DataField="class" HeaderText="班级编号" SortExpression="class" />
                       <asp:BoundField DataField="addr" HeaderText="家庭住址" SortExpression="addr" />
                       <asp:BoundField DataField="beizhu" HeaderText="备注" SortExpression="beizhu" />
                   </Columns>
             <EmptyDataTemplate>
                       现在还没有任何记录!
                   </EmptyDataTemplate>
               </asp:GridView>
               <div id="Data1">
                <fieldset class="myfieldset">
                 <legend>添加学生信息</legend>
                 <br />
                 <table>
                  <tr>
                   <td>
                    <asp:Label ID="lblSid" AssociatedControlID="txtSid" runat="server" Text="学号：" />
                   </td>
                   <td>
                    <asp:TextBox ID="txtSid" runat="server" />
                    <asp:RequiredFieldValidator ID="reqSid" Text="" ErrorMessage="请输入学号!" runat="server" Display="None" ControlToValidate="txtSid" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblName" AssociatedControlID="txtName" runat="server" Text="姓名：" />
                   </td>
                   <td>
                       &nbsp;&nbsp;
                    <asp:TextBox ID="txtName" runat="server" />
                    <asp:RequiredFieldValidator ID="reqName" runat="server" Display="None" Text="" ErrorMessage="请输入姓名!" ControlToValidate="txtName" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblSex" runat="server" AssociatedControlID="txtSex" Text="性别：" />
                   </td>
                   <td>
                    <asp:TextBox ID="txtSex" runat="server" />
                    <asp:RequiredFieldValidator ID="reqSex" runat="server" ControlToValidate="txtSex" Text="" ErrorMessage="请输入性别!" Display="None" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblNati" runat="server" Text="民族：" AssociatedControlID="txtNati" /> 
                   </td>
                   <td>
                    <asp:TextBox ID="txtNati" runat="server" />
                    <asp:RequiredFieldValidator ID="reqNati" runat="server" Text="" ErrorMessage="请输入民族!" Display="None" ControlToValidate="txtNati" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblBir" runat="server" Text="出生日期：" AssociatedControlID="txtBir" />
                   </td>
                   <td>
                    <asp:TextBox ID="txtBir" runat="server" />
                    <asp:RequiredFieldValidator ID="reqBir" runat="server" ControlToValidate="txtBir" Text="" ErrorMessage="请输入出生日期!" Display="None" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblClaid" runat="server" Text="班级编号：" AssociatedControlID="txtClaid" />
                   </td>
                   <td>
                       &nbsp;
                    <asp:TextBox ID="txtClaid" runat="server" />
                    <asp:RequiredFieldValidator ID="reqClaid" ControlToValidate="txtClaid" runat="server" Text="" ErrorMessage="请输入班级编号!" Display="None" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblTime" runat="server" Text="入学时间：" AssociatedControlID="txtTime" />
                   </td>
                   <td>
                       &nbsp;<asp:TextBox ID="txtTime" runat="server" />
                    <asp:RequiredFieldValidator ID="reqTime" runat="server" ControlToValidate="txtTime" Text="" ErrorMessage="请输入入学时间!" Display="None" /> 
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblAdd" runat="server" AssociatedControlID="txtAdd" Text="家庭住址：" />
                   </td>
                   <td>
                       &nbsp;<asp:TextBox ID="txtAdd" runat="server" />
                    <asp:RequiredFieldValidator ID="reqAdd" runat="server" Text="" ErrorMessage="请输入家庭住址!" Display="None" ControlToValidate="txtAdd" />
                   </td>
                  </tr>
                  <tr>
                   <td>
                    <asp:Label ID="lblElse" runat="server" Text="备注：" AssociatedControlID="txtElse" />
                   </td>
                   <td>
                    <asp:TextBox ID="txtElse" runat="server" />
                    <asp:RequiredFieldValidator ID="reqElse" runat="server" Text="" ErrorMessage="请输入备注!" Display="None" ControlToValidate="txtElse" />
                   </td>
                  </tr>
                 </table>
                 <br />
                 <table>
                  <tr>
                   <td class="td1" style="height: 26px">
                    <asp:Button ID="btnOk" runat="server" Text="确定" OnClick="btnOk_Click" />
                   </td>
                   <td class="td1" style="height: 26px">
                    <asp:Button ID="btnCancel" runat="server" Text="取消" CausesValidation="false" />
                   </td>
                  </tr>
                 </table>
                 <asp:ValidationSummary ID="validatorSum1" ShowMessageBox="true" ShowSummary="false" runat="server" />
                </fieldset>
               </div>
             
           <asp:SqlDataSource ID="srcGetStudent" ConnectionString="<%$ ConnectionStrings:DataBaseConnectionString %>" runat="server" DeleteCommand="DELETE FROM [stu] WHERE [id] = @id" InsertCommand="INSERT INTO [stu] ([id], [stu_name], [sex], [nati], [bir], [beizhu], [addr], [Stime], [class]) VALUES (@id, @stu_name, @sex, @nati, @bir, @beizhu, @addr, @Stime, @class)" SelectCommand="SELECT [id], [stu_name], [sex], [nati], [bir], [beizhu], [addr], [Stime], [class] FROM [stu]" UpdateCommand="UPDATE [stu] SET [stu_name] = @stu_name, [sex] = @sex, [nati] = @nati, [bir] = @bir, [beizhu] = @beizhu, [addr] = @addr, [Stime] = @Stime, [class] = @class WHERE [id] = @id" >
               <DeleteParameters>
                   <asp:Parameter Name="id" />
               </DeleteParameters>
               <UpdateParameters>
                   <asp:Parameter Name="stu_name" Type="String" />
                   <asp:Parameter Name="sex" Type="String" />
                   <asp:Parameter Name="nati" Type="String" />
                   <asp:Parameter Name="bir" Type="String" />
                   <asp:Parameter Name="beizhu" Type="String" />
                   <asp:Parameter Name="addr" Type="String" />
                   <asp:Parameter Name="Stime" Type="String" />
                   <asp:Parameter Name="class" Type="String" />
                   <asp:Parameter Name="id" Type="String" />
               </UpdateParameters>
               <InsertParameters>
                   <asp:ControlParameter Name="id" ControlID="txtSid" />
                   <asp:ControlParameter Name="stu_name" ControlID="txtName" />
                   <asp:ControlParameter Name="sex" ControlID="txtSex" />
                   <asp:ControlParameter Name="nati" ControlID="txtNati" />
                   <asp:ControlParameter Name="bir" ControlID="txtBir" />
                   <asp:ControlParameter Name="beizhu" ControlID="txtElse" />
                   <asp:ControlParameter Name="addr" ControlID="txtAdd" />
                   <asp:ControlParameter Name="Stime" ControlID="txtTime" />
                   <asp:ControlParameter Name="class" ControlID="txtClaid" />
               </InsertParameters>
           </asp:SqlDataSource>
</asp:Content>