外文翻译-Visual Basic数据库连接介绍指南.doc

新疆农业大学 英文文献翻译 题 目: Visual Basic程序设计课程教学网站的设计与 实现 姓 名: 陈春 学 院: 计算机与信息工程学院 专 业: 计算机科学与技术 班 级: 042 学 号: 044632208 指导教师: 罗江岩 职称:讲师　 2007年12月25日 新疆农业大学教务处制 Visual Basic Database ConnectivityAn Introductory Guide 1. Create the VB .Net Application Create a blank VB .Net solution in your account and add a newproject to the solution. This should automatically create a blankform for you. Also copy the Authors.mdb database file from the COMP315 library folder into your account. 2. Using Data Adapters and Data Sets To manipulate data in an access database you need to use a data adapter to connect to the database and a data set to manipulate the data. 3. Creating the Data Adapter To create a Data Adapter that contains the SQL statement you want to populate the dataset with, do the following: Click on the Data tab in the tool box and then double click on the OleDbDataAdapter control to add it into the form. The Data Adapter Configuration Wizard will automatically appear to help you configure the Data Adapter. Figure 1. Location of the Data tab in the toolbox. Click on Next to move to the next screen. Now the Data connection to use box should be blank so click on the New Connection button to configure the new connection. Select the Provider tab and then select Microsoft Jet 4.0 OLE DB Provider and then click on Next. In section 1 where it asks for the database to use, click on the … button and then navigate to and select the Authors.mdb database and click on the Open button.. Leave section 2 as it is. Your screen should look similar to this: Figure 2. Completed Data Link Properties. Click on the Test Connection button and you should get a message saying Test Connection Succeeded. If you don’t then check you have foll