Programming with Microsoft Visual Basic 2017
8th Edition
ISBN: 9781337102124
Author: Diane Zak
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 11, Problem 5RQ
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet?
- a. Me.CompanyDataSet.Fill(Me.Sales)
- b. Me.SalesBindingSource.Fill(Me.CompanyDataSet)
- c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales)
- d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Trying to write statements for these shown here and having issues with them working
Which of the following SELECT statements lists only the book with the largest profit? (refer to the tables in the JustLee Books database.)a. SELECT title, MAX(retail-cost)FROM booksGROUP BY title;b. SELECT title, MAX(retail-cost)FROM booksGROUP BY titleHAVING MAX(retail-cost);c. SELECT title, MAX(retail-cost)FROM books;d. none of the above
Write a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2
Chapter 11 Solutions
Programming with Microsoft Visual Basic 2017
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- The primary keys are identified below. The following data types are defined in the SQL Server. tblLevels Level – Identity PKClassName – text 20 – nulls are not allowed tblPoolPool – Identity PKPoolName – text 20 – nulls are not allowedLocation – text 30 tblStaffStaffID – Identity PKFirstName – text 20MiddleInitial – text 3LastName – text 30Suffix – text 3Salaried – BitPayAmount – money tblClassesLessonIndex – Identity PKLevel – Integer FKSectionID – IntegerSemester – TinyIntDays – text 20Time – datetime (formatted for time)Pool – Integer FKInstructor – Integer FKLimit – TinyIntEnrolled – TinyIntPrice – money tblEnrollmentLessonIndex – Integer FKSID – Integer FK (LessonIndex and SID) Primary KeyStatus – text 30Charged – bitAmountPaid – moneyDateEnrolled – datetime tblStudentsSID – Identity PKFirstName – text 20MiddleInitial – text 3LastName – text 30Suffix – text 3Birthday – datetimeLocalStreet – text 30LocalCity – text 20LocalPostalCode – text 6LocalPhone – text 10 Implement this…arrow_forward1- Create a NONGAME table with the following structure: Column Туpe Length Decimal Places Nulls Allowed? Description ITEM NUM CHAR Primary Key 4 No DESCRIPTION CHAR 30 ON HAND DECIMAL 4 CATEGORY CHAR 3 PRICE DECIMAL 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3- In the NONGAME table, change the description of item number DL51 to "Classic Train Set". 4- In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02). 5- Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. 6- Delete every item in the NONGAME table for which the category is PZL. 7- In the NONGAME table, change the category for item FD11 to null. 8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-hand value is a seven-digit…arrow_forwardAccording to tables below, write 3 SELECT statements to exemplify LEFT, RIGHT and FULL OUTER JOIN statements.arrow_forward
- The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER_ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2021-12-28 Driving License Checked: True Rating: 4.0arrow_forwardWrite the appropriate SQL statement for the following:arrow_forwardTrying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.arrow_forward
- Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.arrow_forwardSome rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0arrow_forwardUsing the om database: Write a statement that displays these fields: customer’s first name customer's last name order id order date of orders placed Use the default JOIN type, use table aliases of C for customers and O for orders, and use the ON keyword when joining. The fields should be displayed in the order listed above. Notes: This statement requires joining tables together so I recommend you review the document provided titled 'Notes on database om'. Copy/Paste your answer from your Workbench into the textbox below Remove any "extra" spaces between each keywordarrow_forward
- Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number 8 PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number Bedroom Number 5 Room Status Varchar2 10 REFERENCES to CID in Clients Table CID Numberarrow_forwardUse the following table to answer the question below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a customer Char 5 Primary key custFName stores the first name of a customer Varchar2 35 Cannot be null custLName Stores the last name of a customer Varchar2 35 Cannot be null custGender Store the gender of a customer Char 1 It should be ‘M’ or ‘F’ custDOB Stores the date of birth of a customer Date custIncome Store the income of a customer Number 4 Write a SQL query that displays the number of customers who born on the 16th day of a month . Write in SQL a query that displays the ids of the customers who have the highest income . Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials .arrow_forwardUse the following table to answer the questions below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a customer Char 5 Primary key custFName stores the first name of a customer Varchar2 35 Cannot be null custLName Stores the last name of a customer Varchar2 35 Cannot be null custGender Store the gender of a customer Char 1 It should be ‘M’ or ‘F’ custDOB Stores the date of birth of a customer Date custIncome Store the income of a customer Number 4 Write in SQL a command that creates the table Customers according to the above description (2 marks). Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account (1.5 marks). Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 (1.5 Marks).…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License