Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Customer Incidents Customer ID: 1010 Get Customer Customer ID 1010 Name: Kendall Mayle Address: PO Box 2069 City, State, Zip: Fresno Phone: (559) 555-9999 Emai:

image text in transcribed

Customer Incidents Customer ID: 1010 Get Customer Customer ID 1010 Name: Kendall Mayle Address: PO Box 2069 City, State, Zip: Fresno Phone: (559) 555-9999 Emai: kmayte@mma.fresno.ca.gov CA 93718 Product Date Opened LEAG10 12/7/2015 TEAM 10 12/23/2015 TRNY2012/23/2015 Date Closed 12/8/2015 12/24/2015 Title Could not install Error launching program Unable to activate product Operation When this application starts, a blank Customer Incidents form is displayed. To retrieve a customer, the user enters a customer D and clicks the Get Customer button. Then, the customer data for the customer with that ID is displayed in the text boxes and the incidents for that customer are displayed in the DataGridView control. If a customer with the specified D isn't found, an error message is displayed. Specifications Create a data source with two tables: Customers and Incidents. Include all the columns in the Customers table and all the columns except for TechID and Description in the Incidents table. Add a query to the Customers table adapter that retrieves the data for a customer with a specified D. This query should be used to display the customer data in the text boxes on the form Add a query to the Incidents table adapter that retrieves the incidents for a specified customer. This query should be used to display the incidents in the DataGridView control. Use error handling as necessary throughout this application. Customer Incidents Customer ID: 1010 Get Customer Customer ID 1010 Name: Kendall Mayle Address: PO Box 2069 City, State, Zip: Fresno Phone: (559) 555-9999 Emai: kmayte@mma.fresno.ca.gov CA 93718 Product Date Opened LEAG10 12/7/2015 TEAM 10 12/23/2015 TRNY2012/23/2015 Date Closed 12/8/2015 12/24/2015 Title Could not install Error launching program Unable to activate product Operation When this application starts, a blank Customer Incidents form is displayed. To retrieve a customer, the user enters a customer D and clicks the Get Customer button. Then, the customer data for the customer with that ID is displayed in the text boxes and the incidents for that customer are displayed in the DataGridView control. If a customer with the specified D isn't found, an error message is displayed. Specifications Create a data source with two tables: Customers and Incidents. Include all the columns in the Customers table and all the columns except for TechID and Description in the Incidents table. Add a query to the Customers table adapter that retrieves the data for a customer with a specified D. This query should be used to display the customer data in the text boxes on the form Add a query to the Incidents table adapter that retrieves the incidents for a specified customer. This query should be used to display the incidents in the DataGridView control. Use error handling as necessary throughout this application

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions