vb计算机科学与技术,计算机科学与技术：VB.NET应用教程 978-7-302-09622-1 Advanced VB.NET Chapter 11...-CSDN博客

本文档介绍了VB.NET中数据表单向导(DataFormWizard)和查询构建器(QueryBuilderWindow)的使用方法。通过实例展示了如何连接数据源，设置表格关系，自动生成XSD，以及理解由向导生成的SQL命令，包括SELECT、INSERT、UPDATE和DELETE。同时，提供了练习和家庭作业建议，帮助读者深入理解和应用这些工具。

摘要由CSDN通过智能技术生成

计算机科学与技术：VB.NET应用教程 978-7-302-09622-1 Advanced VB.NET Chapter 11

(43页)

本资源提供全文预览，点击全文预览即可全文预览,如果喜欢文档就下载吧，查找使用更方便哦！

9.90 积分

Chapter 11 More on the Connected Layer ObjectivesThe Data Form WizardThe Query Builder WindowLab 11.1: Exercising the Data Form WizardLab 11.2: Exercising the Data Form Wizard With ParametersSuggested Home Assignments Copyright 2004 Pearson Education, Inc. 2Starting the Data Form Wizard Copyright 2004 Pearson Education, Inc. 3In the WizardmyDataset Enter appropriate Connection Object here Copyright 2004 Pearson Education, Inc. 4Connecting to the Data Source Choose the tables Copyright 2004 Pearson Education, Inc. 5 Specify the Relationships Copyright 2004 Pearson Education, Inc. 6Specify Format Copyright 2004 Pearson Education, Inc. 7Wizard Generated XSD Copyright 2004 Pearson Education, Inc. 8Edit ESD Relationship Copyright 2004 Pearson Education, Inc. 9The Generated Controls OleDbConnection l Specifies the connection to the data source. Dataset l The private copy of the database in VB. OleDbDataAdapter l The Data Adapter has four embedded Command objects, l The Select command to define and populate the dataset from the data source. l The Update, Delete, and Insert commands to carry over the changes made in the dataset back to the data source. Copyright 2004 Pearson Education, Inc. 10A Peek at Chapter 12 Copyright 2004 Pearson Education, Inc. 11The Select Command in the Data Adapter Copyright 2004 Pearson Education, Inc. 12 The Other Generated SQL CommandsINSERT INTO Friends(Baseball, CarType, DoB, FirstName, Gender, Golf, LastName, Salary, Spouse, Telephone, Tennis) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) DELETE FROM Friends WHERE (ID = ?) AND (Baseball = ?) AND (CarType = ? OR ? IS NULL AND CarType IS NULL) AND (DoB = ? OR ? IS NULL AND DoB IS NULL) AND (FirstName = ?) AND (Gender = ? OR ? IS NULL AND Gender IS NULL) AND (Golf = ?) AND (LastName = ?) AND (Salary = ? OR ? IS NULL AND Salary IS NULL) AND (Spouse = ? OR ? IS NULL AND Spouse IS NULL) AND (Telephone = ? OR ? IS NULL AND Telephone IS NULL) AND (Tennis = ?) Copyright 2004 Pearson Education, Inc. 13 The Other Generated SQL CommandsUPDATE Friends SET Baseball = ?, CarType = ?, DoB = ?, FirstName = ?, Gender = ?, Golf = ?, LastName = ?, Salary = ?, Spouse = ?, Telephone = ?, Tennis = ? WHERE (ID = ?) AND (Baseball = ?) AND (CarType = ? OR ? IS NULL AND CarType IS NULL) AND (DoB = ? OR ? IS NULL AND DoB IS NULL) AND (FirstName = ?) AND (Gender = ? OR ? IS NULL AND Gender IS NULL) AND (Golf = ?) AND (LastName = ?) AND (Salary = ? OR ? IS NULL AND Salary IS NULL) AND (Spouse = ? OR ? IS NULL AND Spouse IS NULL) AND (Telephone = ? OR ? IS NULL AND Telephone IS NULL) AND (Tennis = ?) Copyright 2004 Pearson Education, Inc. 14The Bound Controls Copyright 2004 Pearson Education, Inc. 15 ObjectivesThe Data Form WizardThe Query Builder WindowLab 11.1: Exercising the Data Form WizardLab 11.2: Exercising the Data Form Wizard With ParametersSuggested Home Assignments Copyright 2004 Pearson Education, Inc. 16 Open a Connection for the Query Builder 2. Click here.1. Drop a 3. Then Connection here.control on the form. 4. And in the combo window click here. Copyright 2004 Pearson Education, Inc. 17Then Connect to the 关键词：计算机科学与技术：VB.NET应用教程978-7-302-09622-1AdvancedVB.NETChapter11

天天文库所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。

关于本文

本文标题：计算机科学与技术：VB.NET应用教程 978-7-302-09622-1 Advanced VB.NET Chapter 11

链接地址： https://www.wenku365.com/p-43809911.html