【文章內(nèi)容簡介】 可進(jìn)行添加和刪除等相關(guān)操作 如下圖所示 圖 院系管理 ． 2院系管理的相關(guān)代碼 %@ 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 河北科技師范學(xué)院畢業(yè)論文 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 / 河北科技師范學(xué)院畢業(yè)論文 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 / 河北科技師范學(xué)院畢業(yè)論文 17 /UpdateParameters /asp