外文翻譯--visualbasic數(shù)據(jù)庫連接介紹指南-文庫吧資料
2025-05-22 08:22本頁面
【正文】 The first statement clears the dataset of previous information and the second statement uses the fill method of the data adapter to get the new data from the database. The first parameter of the Fill method is the dataset to fill and the second parameter is the name of the table that you used when you set the DataMember property of the data grid control. Now run your application again and when you click on your button you should see all the author information appear. If you click on the column names it will sort the data on that column. Pretty cool eh! 7. Updating Changes Made in the Data Grid You can also change the information by clicking on a cell and then changing the data. Sort by last name and change the surname of 39。 property of the data grid and click on the down arrow and select dsAuthors1. For the 39。 added to your project. 5. Adding a Data Grid Control Now you need to add a data grid control to your form. Do this by selecting the Windows Forms tab in the tool box and then double click on the Data Grid control in the toolbox to add it to your form. Move it around and make it bigger. Go to the 39。 option is selected. Click on the OK button to generate the authors dataset and you should see the Dataset object 39。 data set and give it the name dsAuthors and make sure the 39。 data set rather than 39。. If you don’t then check you have followed the instructions above. Click on OK to return to the Data Adapter Wizard and then click on the Next button. Make sure that Use SQL statements is selected and then click on the Next button. In the large text box type in the following SQL statement: Select * from authors Then click on the Next button and then the Finish button. You may be asked if you want to include a password in the connection string, so just click on Don’t Include Password. You should now see a new Adapter object and a new Connection object. 4. Creating the Dataset The next step is to create a Dataset class based on the query you specified above. Make sure that your Data Adapter object is selected and at the bottom of the properties pane click on the Generate Dataset… link and you should see the window below appear. Figure 3. The Generate Dataset window. Select 39。 button and then navigate to and select the 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 Co
畢業(yè)設計相關(guān)推薦
鄂ICP備17016276號-1