access数据库insert操作(002)

软件技术国家教学资源库建设项目软件开发素材之C源代码一、功能简介ACCESS使用DATAGRIDVIEW显示INSERT操作结果二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介ACCESS数据库INSERT操作。五、程序代码程序名称FORM1CSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMCOMPONENTMODELUSINGSYSTEMDATAUSINGSYSTEMDRAWINGUSINGSYSTEMLINQUSINGSYSTEMTEXTUSINGSYSTEMWINDOWSFORMSUSINGSYSTEMDATAOLEDBNAMESPACEWINDOWSFORMSAPPLICATIONACCESSPUBLICPARTIALCLASSFORM1FORMPRIVATESTATICOLEDBCONNECTIONCONNECTIONPUBLICFORM1INITIALIZECOMPONENTPRIVATEVOIDBTNSHOW_CLICKOBJECTSENDER,EVENTARGSEDATASETDSNEWDATASETSTRINGSQL“INSERTINTONOTESTITLE,CONTENT,AUTHOR,EMAIL,HTTP,PIC,HITS,POSTTIMEVALUES“TXTTITLETEXT“,“TXTCONTENTTEXT“,“TXTAUTHORTEXT“,“TXTEMAILTEXT“,“TXTHTTPTEXT“,“TXTPICTEXT“,“TXTHITSTEXT“,“TXTPOSTTIMETEXT“OLEDBCOMMANDCMDNEWOLEDBCOMMANDSQL,CONNECTIONINTRESULTCMDEXECUTENONQUERYSQL“SELECTFROMNOTES“DSGETDATASETSQLIFDSNULLMESSAGEBOXSHOW“执行成功“DATAGRIDVIEW1DATASOURCEDSTABLES0/调用带异常处理的静态方法/PUBLICSTATICOLEDBCONNECTIONGETCONNSTRINGCONNSTR“PROVIDERMICROSOFTJETOLEDB40DATASOURCE|DATADIRECTORY|BUGTYPESMDB“CONNECTIONNEWOLEDBCONNECTIONCONNSTRTRYCONNECTIONOPENCATCHEXCEPTIONEXCONSOLEWRITELINE“出错N0“,EXMESSAGERETURNNULLRETURNCONNECTION/返回一个DATATABLEPUBLICSTATICDATASETGETDATASETSTRINGSAFESQLDATASETDSNEWDATASETOLEDBCOMMANDCMDNEWOLEDBCOMMANDSAFESQL,CONNECTIONOLEDBDATAADAPTERDANEWOLEDBDATAADAPTERCMDTRYDAFILLDSCATCHDSNULLRETURNDSPRIVATEVOIDFORM1_LOADOBJECTSENDER,EVENTARGSEGETCONNDATASETDSNEWDATASETSTRINGSQL“SELECTFROMNOTES“DSGETDATASE