access数据库select操作(oledbdataadapter)

软件技术国家教学资源库建设项目软件开发素材之C源代码一、名称ACCESS数据库SELECT操作OLEDBDATAADAPTER二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介使用OLEDBDATAADAPTER对ACCESS数据库中的数据执行SELECT操作。五、程序代码程序名称PROGRAMCSUSINGSYSTEMUSINGSYSTEMCOLLECTIONSGENERICUSINGSYSTEMTEXTUSINGSYSTEMDATAUSINGSYSTEMDATAOLEDBNAMESPACESIMPLEACCESSCONNECTIONCLASSPROGRAMSTATICVOIDMAINSTRINGARGSSYSTEMDATADATASETMYDATASET/定义DATASETTRYDATASETDSSTRINGSQLSTR“SELECTCATEGORYID,CATEGORYNAMEFROMCATEGORIES“DSGETDATASETSQLSTRIFDSNULLCONSOLEWRITELINEDSTABLES0COLUMNS1TOSTRINGCATCHEXCEPTIONETHROWNEWEXCEPTION“数据库出错“EMESSAGECONSOLEREADLINE/调用带异常处理的静态方法/PUBLICSTATICOLEDBCONNECTIONGETCONNSTRINGCONNSTR“PROVIDERMICROSOFTJETOLEDB40DATASOURCEBUGTYPESMDB“OLEDBCONNECTIONTEMPCONNNEWOLEDBCONNECTIONCONNSTRTRYTEMPCONNOPENCATCHEXCEPTIONEXCONSOLEWRITELINE“出错N0“,EXMESSAGERETURNNULLRETURNTEMPCONNPRIVATESTATICOLEDBCONNECTIONCONNECTIONPUBLICSTATICOLEDBCONNECTIONCONNECTIONGETSTRINGCONNECTIONSTRING“PROVIDERMICROSOFTACEOLEDB120DATASOURCEBUGTYPESMDB“IFCONNECTIONNULLCONNECTIONNEWOLEDBCONNECTIONCONNECTIONSTRING/打开连接CONNECTIONOPENELSEIFCONNECTIONSTATESYSTEMDATACONNECTIONSTATECLOSEDCONNECTIONOPENELSEIFCONNECTIONSTATESYSTEMDATACONNECTIONSTATEBROKENCONNECTIONCLOSECONNECTIONOPENRETURNCONNECTIONPUBLICSTATICDATASETGETDATASETSTRINGSAFESQLDATASETDSNEWDATASETOLEDBCOMMANDCMDNEWOLEDBCOMMANDSAFESQL,CONNECTIONOLEDBDATAADAPTERDANEW