網(wǎng)上選課系統(tǒng)C#+SQL.doc

-1-延邊大學(xué)本科畢業(yè)論文網(wǎng)上選課系統(tǒng)-維護(hù)及報(bào)表作者李文學(xué)院系工學(xué)院專業(yè)計(jì)算機(jī)科學(xué)與技術(shù)年級(jí)2001級(jí)學(xué)號(hào)2014010370指導(dǎo)教師玄英晨職稱副教授答辯日期2005年6月11日-2-中文摘要網(wǎng)上選課系統(tǒng)是一個(gè)常見(jiàn)的應(yīng)用系統(tǒng),既有B/S結(jié)構(gòu),也有C/S結(jié)構(gòu).與傳統(tǒng)的選課方式相比,網(wǎng)上選課系統(tǒng)利用局域網(wǎng)為學(xué)生選課帶來(lái)了便利.只要選課沒(méi)有截至,學(xué)生就能夠靈活的修改自己的選課情況大大提高了學(xué)校選課工作的效率.VisualC#是最近有Microsoft開(kāi)發(fā)的一種簡(jiǎn)單,精練,類型安全,面向?qū)ο蟮恼Z(yǔ)言,用于生成各種各樣的.NET應(yīng)用程序,包括WEB服務(wù)和ASP.NETWEB的應(yīng)用程序.所我們使用VisualC#來(lái)完成選課系統(tǒng)得制作,選課系統(tǒng)主要是由客戶端和服務(wù)端組成,服務(wù)端是本系統(tǒng)的后臺(tái)數(shù)據(jù)庫(kù),主要使用SQLServer2000關(guān)系數(shù)據(jù)庫(kù).客戶端通過(guò)后臺(tái)服務(wù)器的數(shù)據(jù)存儲(chǔ)來(lái)完成相關(guān)操作.客戶端主要使用VisualC#的Windows窗體TreeView控件和XML文檔來(lái)完成的.與數(shù)據(jù)庫(kù)的連接時(shí),主要調(diào)用DataSet數(shù)據(jù)庫(kù)函數(shù)來(lái)完成客戶端與服務(wù)端的數(shù)據(jù)聯(lián)系,來(lái)實(shí)現(xiàn)選修,修改,刪除的不同的功能.關(guān)鍵詞:TreeView控件,XML文檔,DataSet,SQLServer2000.-3-On-linechoosestheclasssystemisacommonapplicationsystem,alsohastheB/Sstructure,alsohastheC/SstructureChoosestheclasswaywiththetraditiontocompare,on-linechosetheclasssystemtochoosetheclassusingthelocalareanetworkforthestudenttobringtheconvenienceSolongaschoosestheclassnotupto,thestudentcouldnimblereviseownchoosestheclasssituationgreatlytoenhancetheschooltochoosetheclassworktheefficiency.VisualC#wasrecentlyhastheMicrosoftdevelopmentonekindofsimplicity,concise,thetypesecurity,theobject-orientedlanguage,usedintoproducevariousNETapplicationprocedure,includingWEBserviceandASP.NETWEBapplicationprocedure.WeuseVisualC#tocompletechoosetheclasssystemtoresultinthemanufacture,choosestheclasssystemmainlyiscomposedbythecustomerendandtheserviceend,theserviceendisthissystembackstagedatabase,mainlyusesSQLtheServer2,000relationaldatabasesThecustomerendcompletesthecorrelationoperationthroughthebackstageserverdatastorage.ThecustomerendmainlyusesVisualC#WindowswindowTreeViewtocontrolandtheXMLdocumentscompletesWhenwithdatabaseconnection,mainlytransferstheDataSetdatabasefunctiontocompletethecustomerendandtheserviceenddatarelation,realizestakesasanelective,therevision,deletesdifferentfunction.:TreeViewActiveX,XMLdocuments,DataSet,SQLServer2000.-4-目錄第一章緒論51.1VisualC#.NET的簡(jiǎn)介51.2SQLServer2000的簡(jiǎn)介6第二章可行性分析62.1設(shè)計(jì)分析62.2應(yīng)用程序概況7第三章關(guān)鍵的技術(shù)73.1XML文檔對(duì)象模式73.2遍歷DataSet73.3TreeView控件動(dòng)態(tài)綁定數(shù)據(jù)83.4水晶