在線考試系統(tǒng)word版(編輯修改稿)
2024-09-19 16:03 本頁面
【文章內(nèi)容簡介】 ControlStyle Width=80px / /asp:BoundField asp:BoundField DataField=Subject HeaderText=課程 SortExpression=Subject ControlStyle Width=80px / /asp:BoundField asp:BoundField DataField=Paper HeaderText=套題 SortExpression=Paper ControlStyle Width=80px / /asp:BoundField asp:BoundField DataField=Score HeaderText=編號 SortExpression=Score ControlStyle Width=90px / /asp:BoundField asp:CommandField ShowDeleteButton=True ShowEditButton=True / /Columns RowStyle BackColor=EFF3FB / EditRowStyle BackColor=2461BF / SelectedRowStyle BackColor=D1DDF1 FontBold=True ForeColor=333333 / PagerStyle BackColor=2461BF ForeColor=White HorizontalAlign=Center / HeaderStyle BackColor=507CD1 FontBold=True ForeColor=White / AlternatingRowStyle BackColor=White //asp:GridView//定義數(shù)據(jù)源SqlDataSource1，并建立數(shù)據(jù)源內(nèi)容。當建立數(shù)據(jù)源內(nèi)容時要注意的是，這是個可編輯的GridView控件，所以比一般的數(shù)據(jù)源內(nèi)容多一下面的一些語句。一般情況下只有SelectCommand，而現(xiàn)在多了DeleteCommand、InsertCommand、UpdateCommand。 asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=%$ ConnectionStrings:online_ExamConnectionString % DeleteCommand=DELETE FROM [Score] WHERE [id] = @id InsertCommand=INSERT INTO [Score] ([UserID], [UserName], [Major], [Subject], [Paper], [Score]) VALUES (@UserID, @UserName, @Major, @Subject, @Paper, @Score) SelectCommand=SELECT * FROM [Score] UpdateCommand=UPDATE [Score] SET [UserID] = @UserID, [UserName] = @UserName, [Major] = @Major, [Subject] = @Subject, [Paper] = @Paper, [Score] = @Score WHERE [id] = @id//在C里面的代碼，當單擊查詢按鈕時使上面的GridView控件顯示在頁面上protected void Button1_Click(object sender, EventArgs e) { = true。 }2．后臺管理員查詢成績界面后臺管理員查詢成績界面設(shè)計見下圖5在系統(tǒng)的后臺界面，管理員只要輸入考生的ID號，點擊查詢按鈕之后即可查詢學(xué)生的考試成績。具體實現(xiàn)的代碼如下：圖5//本段是設(shè)計界面源里的代碼，下面是GridView的樣式設(shè)計并綁定到下面的數(shù)據(jù)源SqlDataSource1。asp:GridView ID=GridView1 runat=server AutoGenerateColumns=False DataSourceID=SqlDataSource1 Visible=False Width=696px CellPadding=4 ForeColor=333333 GridLines=None Columns asp:BoundField DataField=UserID HeaderText=用戶ID SortExpression=UserID / asp:BoundField DataField=UserName HeaderText=用戶名 SortExpression=UserName / asp:BoundField DataField=Major HeaderText=專業(yè) SortExpression=Major / asp:BoundField DataField=Subject HeaderText=課程 SortExpression=Subject / asp:BoundField DataField=Paper HeaderText=套題 SortExpression=Paper /
外語相關(guān)推薦
鄂ICP備17016276號-1