【正文】
nnection button and you should get a message saying 39。 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 OLE DB Provider and then click on Next. In section 1 where it asks for the database to use, click on the 39。 英文文獻(xiàn)翻譯 題 目 : Visual Basic 程序設(shè)計(jì)課程教學(xué)網(wǎng)站的設(shè)計(jì)與 實(shí)現(xiàn) 姓 名 : 學(xué) 院 : 計(jì)算機(jī)與信息工程學(xué)院 專 業(yè) : 計(jì)算機(jī)科學(xué)與技術(shù) 班 級(jí) : 學(xué) 號(hào) : 指 導(dǎo)教師 : 職稱 :講師 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 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 39。Data39?!?9。Test Connection Succeeded39。New39。Existing39。Add This Dataset to the Designer39。dsAuthors139。DataSource39。DataMember39。Ann Dull39。Ann Exciting39。Dull39。t affect the data in the actual table in the access database. You need to use the Update method of the Data Adapter to save any changes made to the dataset to the database. To do this first add another button the form and give it the caption Save and then create a click event procedure for the button. Then type in the following statement in the click event procedure: (DsAuthors1) This statement calls the Update method of the Data Adapter and you need to specify the dataset to update as the parameter. Now run the application again and change the surname again and the