【正文】 d 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 / 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 / /UpdateParameters /asp:SqlDataSource/div/asp:Content 課程管理 課程管理視圖 院系管理窗口可以學(xué)校的院系進(jìn)行管理，可進(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:Contentasp:Content ID=Content2 ContentPlaceHolderID=ContentPlaceHolder1 runat=server asp:GridView ID=GridView1 runat=server AllowPaging=True AllowSorting=True AutoGenerateColumns=False DataKeyNames=C_id DataSourceID=SqlDataSource1 Columns asp:BoundField DataField=C_Num HeaderText=課程編號 SortExpression=C_Num / asp:BoundField DataField=C_Name HeaderText=課程名 SortExpression=C_Name / asp:BoundField DataField=C_XingZhi HeaderText=課程性質(zhì) SortExpression=C_XingZhi / asp:BoundField DataField=C_XueFen HeaderText=學(xué)分 SortExpression=C_XueFen / asp:CommandField ShowDeleteButton=True ShowEditButton=True / /Columns/asp:GridViewasp:SqlDataSource ID=SqlDataSource1 runat=server ConflictDetection=CompareAllValues ConnectionString=%$ ConnectionStrings:StudentMSConnectionString3 % 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] 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