【正文】 數(shù)據(jù)庫中的數(shù)據(jù)讀DataSet中 MyDataTable=[”Table”]。 SqlCommand MySqlCommand =new SqlCommand(NonQueryString, MysqlConnection)。 ()。如，通過設(shè)置 DataGrid的 AllowSorting屬性為 true，并加入少量代碼， DataGrid就具備了按不同字段排序的功能。一行用來設(shè)定與 DataGrid綁定的數(shù)據(jù)源（ DataSource），另一條則用來執(zhí)行綁定命令（ DataBind()。 這樣有許多好處： 8 可控制列的順序。在前一個示例中，列標頭指明了字段名，這可能并不合適。 每個在 DataGrid中的列都是 DataGridColumn類的一個實例。 因為 DataGrid是從 WebControl得到的，所以 DataGrid控件繼承了諸如 Width、BackColor、 BorderStyle和 。這些樣式控制著它們相應(yīng)項目的外觀。此屬性可隨格式化類型 （如日期或貨幣）一起預(yù)置或附加任意內(nèi)容。它識別標準命令 ,該命令使其更改它的屬性，并通過觸發(fā)此事件來將此更改通知用戶的代碼。 ()。 ID是通過訪問 DataKeys集合進行檢索的。但是盡管 DataGrid有這樣那樣令人印象深刻的優(yōu)點，它的兩個缺點也同樣不能忽視。相對于 DataList ， Repeater來說，DataGrid性能要差一些。 總結(jié) 從實踐容易看出，利用 ASP框架技術(shù)進行動態(tài) Web數(shù)據(jù)庫應(yīng)用系統(tǒng)的開發(fā)十分便捷?；緦崿F(xiàn)了初期的設(shè)計。主要是因為在開發(fā)學生管理信息系統(tǒng)時接觸到比較多的新軟件以及使用了一些以前未接觸過的新技術(shù)。還是存在著數(shù)據(jù)的完整性不是很好的保持，查詢未能實現(xiàn)組合查詢等缺陷。特別感謝徐安排老師在繁忙的工作之余抽出時間仔細審閱，并給了我很好的建議。一并感謝何鑫同學的督促和指導。s about the only thing I wouldn39。t admit even to himself that there were some things other people could do better. If you kept beating him at anything you had to be cheating. He started a nasty argument over it one nightcould have gotten seriousbut Gerard and Caine broke it up. G ive Caine that. He took my part that time. Poor guy . . . Hell of a way to go, you know? His throat . . . Well, anyhow, there I was in Texorami, making music and women, winning at cards and jockeying around the sky. Palm trees and nightblooming wallflowers. Lots of good port smellsspices, coffee, tar, saltyou know. Gentlefolk, merchants, and peons the same straights as in most other places. Sailors and assorted travelers passing in and out. Guys like me living around the edges of things. I spent a little over two years in Texorami, happy. Really. Not much contact with the others. Sort of postcard like hellos via the Trumps every now and then, and that was about it. Amber was pretty much off my mind. All this changed one night when I was sitting there with a full house and the guy across from me was trying to make up his mind whether or not I was bluffing. The Jack of Diamonds began talking to me. Yes, that is how it started. I was in a weird frame of mind anyway. I had just finished a couple very hot sets and was still kind of high. A lso, I was physically strung out from a long day39。s the matter? . . . prisoner, he said, and som ething else that I couldn39。t answering, he wasn39。t know how they would work there, but that wardenthing had been awfully brightand it never hurts to try anything extra you can think of. For that matter, I also took a gun. I had a feeling it would be worthless, and I was right. But, like I said, you never know till you try. The only person I said goodbye to was another drummer, because I stopped to give him my set before I left. I knew he39。s what I meant a。t know whether you39。d say, that made me decide to go it alone and try to rescue him. I dusted off my own Trumps and tried reaching him again. A s you might expect, there was no response. I got a good night39。t bring you through, he said. No Trumps, and I am too weak. You will have to e the long way around.... I did not ask him how he was managing it without my Trump. Finding out where he was seemed of first importance. I asked him how I could locate him. Look very closely, he said. Remember every feature. I may only be able to show you once. Come armed, too. . . . Then I saw the landscapeover his shoulder, out a window, over a battlement, I can39。t know. The Jac k said, Random. Then its face blurred and it said, Help me. I began getting a feel of the personality by then, but it was weak. The whole thing was very weak. T hen the face rearranged itself and I saw that I was right. It was Brand. He looked like hell, and he seemed to be chained or tied to something. Help me, he said again. I39。m good and I39。t wait. And the air currents were fabulous. I had a little red sail plane I used to go sky surfing in, every couple of days. It was the good life. I played drums till all hours in a basement spot up the river where the walls sweated almost as much as the customers and the smoke used to wash around the lights like streams of milk. When I was done playing I39。感謝學校黨委組織部的白老師在資料提供、論文修改方面給予我的大力支持。 總的來說，經(jīng)過本次畢業(yè)設(shè)計，培養(yǎng)了自己的動手能力，提高了自己的自學能力和解決問題的能力，豐富了自己的專業(yè)知識和專業(yè)技能 。而整個設(shè)計時間比較倉促，在材料收集、整理方面還有做得不夠的地方，這很是影響了整個系統(tǒng)的豐富程度。它簡單、實用，通過人機對話的動態(tài)交互方式獲取所需信息，操作簡單，易用。 4 結(jié)束語 經(jīng)過三個多月的設(shè)計和開發(fā)，學生管理信息系統(tǒng)基本開發(fā)完畢。當然，可以關(guān)閉 ViewState功能，但代價是將不能使用排序、分頁以及記錄編輯等功能。當然，可以定制字體、顏色以及線條寬度等等，但它始終只能是 HTML表格。通常，將它設(shè)置為主關(guān)鍵字或使用戶可以唯一標識項目的某些其它字段，并將此信息用作后續(xù)的數(shù)據(jù)庫查詢或過濾數(shù)據(jù)中的準則。 DataGrid處理命令事件，該事件是通過包含在其項目中的按鈕觸發(fā)的。 MysqlConnection .Open()。如果未指定格式，則使用該值的 ToString方法。這是通過設(shè)置 Bound Column的 DataFormatString屬性值完成的。這些屬性允許從總體上定制控件。 BoundColumn將 DataSource的字段值顯示為純文本； ButtonColumn不綁定任何的字段，它包含有五種 DataGrid 的 事 件 ： DataGrid1_SelectedIndexChanged 選擇，DataGrid1_EditCommand 編 輯 ， DataGrid1_CancelCommand 取消，DataGrid1_UpdateCommand新 ,DataGrid1_DeleteCommand刪除，只需要添加少量代碼， DataGrid就具備對綁定數(shù)據(jù)進行刪除，更新的功能； HyperLinkColumn將其顯示為一個超級鏈接； TemplateColumn則是將綁定了的字段列轉(zhuǎn)換為可以編輯的模板。 10 自動生成的列的類型始終是 BoundColumn。另一方面，自動生成的列是用映像檢索到的順 序表示的，此順序不必與代碼中的列順序或數(shù)據(jù)庫表本身的列順序相匹配。當設(shè)置為 true時， DataGrid將使用 reflection檢查其數(shù)據(jù)源和對象，并為每個公用屬性或字段創(chuàng)建一個列。除了在可用性方面的支持以外， DataGrid同時也相當節(jié)省開發(fā)時間。每一條記錄輸出時會建立 一對 tr標簽，而每個字段的值輸出時則建立一對 td標簽。 } catch(Exception e) { (())。 } return MyDataTable。 SqlDataAdapter sqlDataAdapter=new MySqlDataAdapter(QueryStrng,MysqlConnection)。利用 SqlCommand對象設(shè)置相應(yīng)的 SQL命令來完成相應(yīng)的操作。 //初始化一個適配器 protected MyDataSet。//打開聯(lián)接 (3)讀取數(shù)據(jù)。利用 SqlConnection對象的 ConnectionString屬性可指定連接參數(shù) [4]。但是與 ASP框架技術(shù)相比較，運用ADO和 ASP技術(shù)實現(xiàn)的動態(tài) Web應(yīng)用需要進行大量的編程工作，而在 ASP框架技術(shù)中提供了一些功能非常強大的窗體控件，可以節(jié)省大部分的編程工作。數(shù)據(jù)庫服務(wù)器端負責管理數(shù)據(jù)庫，處 理數(shù)據(jù)更新及完成查詢要求、運行存儲過程 [6]。 ASP與數(shù)據(jù)庫 在 Inter還沒有開始流行的年代， Client/Server體系的二層結(jié)構(gòu)是局域網(wǎng)環(huán)境中數(shù)據(jù)庫應(yīng)用系統(tǒng)的主流結(jié)構(gòu)。開發(fā)人員可以方便地獲得這些技術(shù)的優(yōu)點，其中包括托管的公共語言運行庫環(huán)境、類型安全、繼承等等?？梢酝ㄟ^在現(xiàn)有 ASP應(yīng)用程序中逐漸添加 ASP功能，隨時增強該 ASP應(yīng)用程序的功能 [5]。而其中的 ASP是下一代 ASP（ Active Server Page），