access使用datagridview显示自定义delete操作结果

软件技术国家教学资源库建设项目软件开发素材之C源代码一、名称ACCESS使用DATAGRIDVIEW显示自定义DELETE操作结果二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介使用DATAGRIDVIEW显示自定义DELETE操作删除ACCESS数据库数据的结果。五、程序代码程序名称FORM1CSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMCOMPONENTMODELUSINGSYSTEMDATAUSINGSYSTEMDRAWINGUSINGSYSTEMLINQUSINGSYSTEMTEXTUSINGSYSTEMWINDOWSFORMSUSINGSYSTEMDATAOLEDBNAMESPACEACCESSGVDEFINEDELETEPUBLICPARTIALCLASSFORM1FORMPUBLICFORM1INITIALIZECOMPONENTSTRINGCONN“PROVIDERMICROSOFTJETOLEDB40DATASOURCEINFORMATIONMDBPERSISTSECURITYINFOTRUEJETOLEDBDATABASEPASSWORD123456“PRIVATEVOIDFORM1_LOADOBJECTSENDER,EVENTARGSEOLEDBCONNECTIONCONNECTIONNEWOLEDBCONNECTIONCONNCONNECTIONOPENDATASETDSNEWDATASETSTRINGSQL“SELECTFROMSCORE“DSGETDATASETSQLIFDSNULLDATAGRIDVIEW1DATASOURCEDSTABLES0/返回一个DATATABLEPUBLICDATASETGETDATASETSTRINGSAFESQLOLEDBCONNECTIONCONNECTIONNEWOLEDBCONNECTIONCONNCONNECTIONOPENDATASETDSNEWDATASETOLEDBCOMMANDCMDNEWOLEDBCOMMANDSAFESQL,CONNECTIONOLEDBDATAADAPTERDANEWOLEDBDATAADAPTERCMDTRYDAFILLDSCATCHDSNULLRETURNDSPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,EVENTARGSEOLEDBCONNECTIONCONNECTIONNEWOLEDBCONNECTIONCONNCONNECTIONOPENDATASETDSNEWDATASETSTRINGSQLSTR“DELETEFROMSCOREWHEREID“INTPARSETEXTBOX1TEXT“OLEDBCOMMANDCMDNEWOLEDBCOMMANDSQLSTR,CONNECTIONINTRESULTCMDEXECUTENONQUERYSQLSTR“SELECTFROMSCORE“DSGETDATASETSQLSTRIFDSNULLMESSAGEBOXSHOW“执行成功“DATAGRIDVIEW1DATASOURCEDSTABLES0STRINGSQL“SELECTFROMSCORE“DS