毕业论文外文翻译-VB的数据库编程分析

《毕业论文外文翻译-VB的数据库编程分析》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、ANALYSISOFDATABASEPROGRAMMINGINVBVB(VisualBasic)isavisualizationprogrammingenvironmentthatMicrosoftCorporationpromotesbasedontheBasiclanguage.Itissimpleandeasytostudy.Ithasformidablefunctionsothatmanycomputeramateursreallylikeit.AlotofapplicationsoftwaresalluseVBasthesof

2、twaredevelopmentplatform.WhenweuseVBtodeveloptheapplicationsoftware,howtousethedatabaseandcarryonthemanagementofthedatabaseisconcernedbyallexploiters.VBhasprovidedmanytoolsandmethodsfordatabaseprogramming.Whatmethodisusedtovisitthedatabasedependsonusers’differentdemands,

3、asimpleanalysisoftheVBdatabaseprogrammingisexplainedasfollowings.1.DAOTechnologyByusingMicrosoftcompany’sJetDatabaseEngine(Jetdatabaseengine),DAO(DataAccessObject)thetechnologymainlyprovidesvisittoISAM(smoothindexsearchmethod)typedatabase,suchastherealizationofthevisitt

4、odatabaselikeFoxPro,Access,Dbase.1.1UseDataControlsDatacontrolsareproducedbyusing“Data”buttoninthetoolbox.Ithas3basicattributes:Connect,DatabaseNameandRecordSource.Connectattributespecifysthedatabasetypethatdatacontrolsvisit,thedefaultdatabaseistheAccessdatabase.Thevalu

5、eoftheDatabaseNameattributeisthedatabasefilenamewhichcontainsthecompletepath.TheRecordSourceattributeistherecordsetthatwevisit,alsocanbetablesorSQLsentences.IfwewillvisittablestudofdatabasefileteachermdbofTEMPfolderunderDplate,thenDatacontrols’sConnectattributeisnull,and

6、theDatabaseNameattributeis“D:tempteachermdb”,thevalueoftheRecordSourceattributeis“stud”.ThiscanaccomplishthebindingbetweenDatacontrolsanddatabaserecords.ThroughthemethodsofDatacontrolslikeAddnew,Update,Delete,Movelast,wecanvisitthedatabaseaseveryrequest.Whenwebrowsethe

7、contentindatabase,DatacontrollsisusedfrequentlywithDBGrid,itprovidesdatainquiryingridway.1.2UseDAOObjectStorehouseThemodeloftheDAOobjectstorehouseismainlyusinghierarchicalstructure,Dentineistheobjectinthetopmoststory,belowitaretwoobjectsets,Errorsandworkspace,underthewor

8、kspaceobject,istheDatabasesset.WhentheapplicationprocedurequotestheDAOobjectstorehouse,itproducesonlyaD