高校学生管理系统设计与实现(编辑修改稿)内容摘要:

可进行添加和删除等相关操作 如下图所示 图 院系管理 . 2院系管理的相关代码 %@ Page Title= Language=C MasterPageFile=~/Master/ AutoEventWireup=true CodeBehind= Inherits= % asp:Content ID=Content1 ContentPlaceHolderID=head runat=server /asp:Content asp:Content ID=Content2 ContentPlaceHolderID=ContentPlaceHolder1 runat=server div class=right asp:GridView ID=GridView1 runat=server AutoGenerateColumns=False DataKeyNames=Y_Id DataSourceID=SqlDataSource3 AllowPaging=True AllowSorting=True Columns asp:BoundField DataField=Y_Id HeaderText= 院 系 代 号 InsertVisible=False ReadOnly=True SortExpression=Y_Id / asp:BoundField DataField=Y_name HeaderText= 院系名字 SortExpression=Y_name / asp:CommandField ShowDeleteButton=True ShowEditButton=True / /Columns /asp:GridView asp:SqlDataSource ID=SqlDataSource3 runat=server ConflictDetection=CompareAllValues 河北科技师范学院毕业论文 15 ConnectionString=%$ ConnectionStrings:StudentMSConnectionString3 % DeleteCommand=DELETE FROM [T_YuanXi] WHERE [Y_Id] = @original_Y_Id AND [Y_name] = @original_Y_name InsertCommand=INSERT INTO [T_YuanXi] ([Y_name]) VALUES (@Y_name) OldValuesParameterFormatString=original_{0} SelectCommand=SELECT [Y_Id], [Y_name] FROM [T_YuanXi] UpdateCommand=UPDATE [T_YuanXi] SET [Y_name] = @Y_name WHERE [Y_Id] = @original_Y_Id AND [Y_name] = @original_Y_name DeleteParameters asp:Parameter Name=original_Y_Id Type=Int32 / asp:Parameter Name=original_Y_name Type=String / /DeleteParameters InsertParameters asp:Parameter Name=Y_name Type=String / /InsertParameters UpdateParameters asp:Parameter Name=Y_name Type=String / asp:Parameter Name=original_Y_Id Type=Int32 / asp:Parameter Name=original_Y_name Type=String / /UpdateParameters /asp:SqlDataSource asp:SqlDataSource ID=SqlDataSource2 runat=server ConnectionString=%$ ConnectionStrings:StudentMSConnectionString3 % DeleteCommand=DELETE FROM [T_Course] WHERE [C_id] = @C_id InsertCommand=INSERT INTO [T_Course] ([C_Num], [C_Name], [C_XingZhi], [C_XueFen]) VALUES (@C_Num, @C_Name, @C_XingZhi, @C_XueFen) SelectCommand=SELECT [C_id], [C_Num], [C_Name], [C_XingZhi], [C_XueFen] FROM [T_Course] UpdateCommand=UPDATE [T_Course] SET [C_Num] = @C_Num, [C_Name] = @C_Name, [C_XingZhi] = @C_XingZhi, [C_XueFen] = @C_XueFen WHERE [C_id] = @C_id DeleteParameters asp:Parameter Name=C_id Type=Int32 / /DeleteParameters InsertParameters asp:Parameter Name=C_Num Type=Int32 / asp:Parameter Name=C_Name Type=String / asp:Parameter Name=C_XingZhi Type=String / asp:Parameter Name=C_XueFen Type=Int32 / /InsertParameters UpdateParameters asp:Parameter Name=C_Num Type=Int32 / asp:Parameter Name=C_Name Type=String / 河北科技师范学院毕业论文 16 asp:Parameter Name=C_XingZhi Type=String / asp:Parameter Name=C_XueFen Type=Int32 / asp:Parameter Name=C_id Type=Int32 / /UpdateParameters /asp:SqlDataSource asp:SqlDataSource ID=SqlDataSource1 runat=server ConflictDetection=CompareAllValues ConnectionString=%$ ConnectionStrings:StudentMSConnectionString4 % DeleteCommand=DELETE FROM [T_Course] WHERE [C_id] = @original_C_id AND [C_Num] = @original_C_Num AND [C_Name] = @original_C_Name AND [C_XingZhi] = @original_C_XingZhi AND [C_XueFen] = @original_C_XueFen InsertCommand=INSERT INTO [T_Course] ([C_Num], [C_Name], [C_XingZhi], [C_XueFen]) VALUES (@C_Num, @C_Name, @C_XingZhi, @C_XueFen) OldValuesParameterFormatString=original_{0} SelectCommand=SELECT [C_id], [C_Num], [C_Name], [C_XingZhi], [C_XueFen] FROM [T_Course] ORDER BY [C_id] UpdateCommand=UPDATE [T_Course] SET [C_Num] = @C_Num, [C_Name] = @C_Name, [C_XingZhi] = @C_XingZhi, [C_XueFen] = @C_XueFen WHERE [C_id] = @original_C_id AND [C_Num] = @original_C_Num AND [C_Name] = @original_C_Name AND [C_XingZhi] = @original_C_XingZhi AND [C_XueFen] = @original_C_XueFen DeleteParameters asp:Parameter Name=original_C_id Type=Int32 / asp:Parameter Name=original_C_Num Type=Int32 / asp:Parameter Name=original_C_Name Type=String / asp:Parameter Name=original_C_XingZhi Type=String / asp:Parameter Name=original_C_XueFen Type=Int32 / /DeleteParameters InsertParameters asp:Parameter Name=C_Num Type=Int32 / asp:Parameter Name=C_Name Type=String / asp:Parameter Name=C_XingZhi Type=String / asp:Parameter Name=C_XueFen Type=Int32 / /InsertParameters UpdateParameters asp:Parameter Name=C_Num Type=Int32 / asp:Parameter Name=C_Name Type=String / asp:Parameter Name=C_XingZhi Type=String / asp:Parameter Name=C_XueFen Type=Int32 / asp:Parameter Name=original_C_id Type=Int32 / asp:Parameter Name=original_C_Num Type=Int32 / asp:Parameter Name=original_C_Name Type=String / asp:Parameter Name=original_C_XingZhi Type=String / asp:Parameter Name=original_C_XueFen Type=Int32 / 河北科技师范学院毕业论文 17 /UpdateParameters /asp。
阅读剩余 0%
本站所有文章资讯、展示的图片素材等内容均为注册用户上传(部分报媒/平媒内容转载自网络合作媒体),仅供学习参考。 用户通过本站上传、发布的任何内容的知识产权归属用户或原始著作权人所有。如有侵犯您的版权,请联系我们反馈本站将在三个工作日内改正。