軟件技術(shù)國家教學(xué)資源庫建設(shè)項目軟件開發(fā)素材之C源代碼一、功能簡介ACCESS使用DATAGRIDVIEW顯示INSERT操作結(jié)果二、創(chuàng)建或搜集相關(guān)信息搜集單位重慶電子工程職業(yè)學(xué)院搜集時間20120805來源互聯(lián)網(wǎng)三、適用對象學(xué)生、教師、C及ASPNET項目開發(fā)人員、相關(guān)技術(shù)人員等。四、功能簡介ACCESS數(shù)據(jù)庫INSERT操作。五、程序代碼程序名稱FORM1CSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMCOMPONENTMODELUSINGSYSTEMDATAUSINGSYSTEMDRAWINGUSINGSYSTEMLINQUSINGSYSTEMTEXTUSINGSYSTEMWINDOWSFORMSUSINGSYSTEMDATAOLEDBNAMESPACEWINDOWSFORMSAPPLICATIONACCESSPUBLICPARTIALCLASSFORM1FORMPRIVATESTATICOLEDBCONNECTIONCONNECTIONPUBLICFORM1INITIALIZECOMPONENTPRIVATEVOIDBTNSHOW_CLICKOBJECTSENDER,EVENTARGSEDATASETDSNEWDATASETSTRINGSQL“INSERTINTONOTESTITLE,CONTENT,AUTHOR,EMAIL,HTTP,PIC,HITS,POSTTIMEVALUES“TXTTITLETEXT“,“TXTCONTENTTEXT“,“TXTAUTHORTEXT“,“TXTEMAILTEXT“,“TXTHTTPTEXT“,“TXTPICTEXT“,“TXTHITSTEXT“,“TXTPOSTTIMETEXT“OLEDBCOMMANDCMDNEWOLEDBCOMMANDSQL,CONNECTIONINTRESULTCMDEXECUTENONQUERYSQL“SELECTFROMNOTES“DSGETDATASETSQLIFDSNULLMESSAGEBOXSHOW“執(zhí)行成功“DATAGRIDVIEW1DATASOURCEDSTABLES0/調(diào)用帶異常處理的靜態(tài)方法/PUBLICSTATICOLEDBCONNECTIONGETCONNSTRINGCONNSTR“PROVIDERMICROSOFTJETOLEDB40DATASOURCE|DATADIRECTORY|BUGTYPESMDB“CONNECTIONNEWOLEDBCONNECTIONCONNSTRTRYCONNECTIONOPENCATCHEXCEPTIONEXCONSOLEWRITELINE“出錯N0“,EXMESSAGERETURNNULLRETURNCONNECTION/返回一個DATATABLEPUBLICSTATICDATASETGETDATASETSTRINGSAFESQLDATASETDSNEWDATASETOLEDBCOMMANDCMDNEWOLEDBCOMMANDSAFESQL,CONNECTIONOLEDBDATAADAPTERDANEWOLEDBDATAADAPTERCMDTRYDAFILLDSCATCHDSNULLRETURNDSPRIVATEVOIDFORM1_LOADOBJECTSENDER,EVENTARGSEGETCONNDATASETDSNEWDATASETSTRINGSQL“SELECTFROMNOTES“DSGETDATASE