【正文】 iMianMao HeaderText=政治面貌 SortExpression=S_ZhengZhiMianMao / asp:BoundField DataField=S_YuanXi HeaderText=院系 SortExpression=S_YuanXi / asp:BoundField DataField=S_BanJi HeaderText=班級 SortExpression=S_BanJi / asp:BoundField DataField=S_HomeAddress HeaderText=家庭地址 SortExpression=S_HomeAddress / asp:BoundField DataField=S_JiGuan HeaderText=籍貫 SortExpression=S_JiGuan / asp:CommandField ShowEditButton=True / asp:CommandField ShowDeleteButton=True / /Columns /asp:GridView asp:SqlDataSource ID=SqlDataSource2 runat=server ConflictDetection=CompareAllValues ConnectionString=%$ ConnectionStrings:StudentMSConnectionString3 % DeleteCommand=DELETE FROM [T_Student] WHERE [S_id] = original_S_id AND [S_Num] = original_S_Num AND [S_Name] = original_S_Name AND [S_Sex] = original_S_Sex AND [S_ZhengZhiMianMao] = original_S_ZhengZhiMianMao AND [S_YuanXi] = original_S_YuanXi AND [S_BanJi] = original_S_BanJi AND [S_HomeAddress] = original_S_HomeAddress AND [S_JiGuan] = original_S_JiGuan InsertCommand=INSERT INTO [T_Student] ([S_Num], [S_Name], [S_Sex], [S_ZhengZhiMianMao], [S_YuanXi], [S_BanJi], [S_HomeAddress], [S_JiGuan]) VALUES (S_Num, S_Name, S_Sex, S_ZhengZhiMianMao, S_YuanXi, S_BanJi, S_HomeAddress, S_JiGuan) OldValuesParameterFormatString=original_{0} SelectCommand=SELECT [S_id], [S_Num], [S_Name], [S_Sex], [S_ZhengZhiMianMao], [S_YuanXi], [S_BanJi], [S_HomeAddress], [S_JiGuan] FROM [T_Student] ORDER BY [S_id] UpdateCommand=UPDATE [T_Student] SET [S_Num] = S_Num, [S_Name] = S_Name, [S_Sex] = S_Sex, [S_ZhengZhiMianMao] = 河北科技師范學(xué)院畢業(yè)論文 21 S_ZhengZhiMianMao, [S_YuanXi] = S_YuanXi, [S_BanJi] = S_BanJi, [S_HomeAddress] = S_HomeAddress, [S_JiGuan] = S_JiGuan WHERE [S_id] = original_S_id AND [S_Num] = original_S_Num AND [S_Name] = original_S_Name AND [S_Sex] = original_S_Sex AND [S_ZhengZhiMianMao] = original_S_ZhengZhiMianMao AND [S_YuanXi] = original_S_YuanXi AND [S_BanJi] = original_S_BanJi AND [S_HomeAddress] = original_S_HomeAddress AND [S_JiGuan] = original_S_JiGuan DeleteParameters asp:Parameter Name=original_S_id Type=Int32 / asp:Parameter Name=original_S_Num Type=String / asp:Parameter Name=original_S_Name Type=String / asp:Parameter Name=original_S_Sex Type=String / asp:Parameter Name=original_S_ZhengZhiMianMao Type=String / asp:Parameter Name=original_S_YuanXi Type=String / asp:Parameter Name=original_S_BanJi Type=String / asp:Parameter Name=original_S_HomeAddress Type=String / asp:Parameter Name=original_S_JiGuan Type=String / /DeleteParameters InsertParameters asp:Parameter Name=S_Num Type=String / asp:Parameter Name=S_Name Type=String / asp:Parameter Name=S_Sex Type=String / asp:Parameter Name=S_ZhengZhiMianMao Type=String / asp:Parameter Name=S_YuanXi Type=String / asp:Parameter Name=S_BanJi Type=String / asp:Parameter Name=S_HomeAddress Type=String / asp:Parameter Name=S_JiGuan Type=String / /InsertParameters UpdateParameters asp:Parameter Name=S_Num Type=String / asp:Parameter Name=S_Name Type=String / asp:Parameter Name=S_Sex Type=String / 河北科技師范學(xué)院畢業(yè)論文 22 asp:Parameter Name=S_ZhengZhiMianMao Type=String / asp:Parameter Name=S_YuanXi Type=String / asp:Parameter Name=S_BanJi Type=String / asp:Parameter Name=S_HomeAddress Type=String / asp:Parameter Name=S_JiGuan Type=String / asp:Parameter Name=original_S_id Type=Int32 / asp:Parameter Name=original_S_Num Type=String / asp:Parameter Name=original_S_Name Type=String / asp:Parameter Name=original_S_Sex Type=String / asp:Parameter Name=original_S_ZhengZhiMianMao Type=String / asp:Parameter Name=original_S_YuanXi Type=String / asp:Parameter Name=original_S_BanJi Type=String / asp:Parameter Name=original_S_HomeAddress Type=String / asp:Parameter Name=original_S_JiGuan Type=String / /UpdateParameters /asp:SqlDataSource asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=%$ ConnectionStrings:StudentMSConnectionString % SelectCommand=SELECT * FROM [T_Student]/asp:SqlDataSource /div /asp:Content 河北科技師范學(xué)院畢業(yè)論文 23 成績管理 成績管理視圖 成績管理窗口可以 對學(xué)生的成績進(jìn)行添加和刪除等相關(guān)操作 如下圖所示 圖 成績管理 成績管理的相關(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 asp:GridView ID=GridView1 runat=server AllowPaging=True AllowSorting=True AutoGenerateColumns=False DataSourceID=SqlDataSource1 Columns asp:BoundField DataField=M_Stu_id HeaderText=學(xué)生學(xué)號 SortExpression=M_Stu_id / asp:BoundField DataField=M_Course_id HeaderText=課程編號 SortExpression=M_Course_id /