Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please HELP me in Visual Basic!!! Please provide me VB code and also the design if you have it too. I will thump up if

Please HELP me in Visual Basic!!! Please provide me VB code and also the design if you have it too. I will thump up if your answer help!!!image text in transcribedimage text in transcribedimage text in transcribed

Objectives 1. Create VB applications that use databases. 2. Connect to a database 3. Use the DataGrid View control 4. Use data bound controls 5. Query using data from a database 6. Use SQL to query Situation Using the Karate database that came with the textbook, create a complete query application. You are to complete Chapter 10: Programming Challenges 58. Include pre-defined queries with an appropriate name for each query. All these Challenges are to be displayed as menu options. For example, results for Programming Challenge 5 and 6 will be displayed for a menu option titled "List Members by Join Date". Group the menu options meaningfully. You are to also include menu options that will: 1. Display the first name, last name and phone numbers of all members of the Kyoshi Karate School. 2. Display details of all payments made to the Kyoshi Karate School. Each of the queries can display results on separate forms. Include on each separate form, a menu option to close the form. Refer to the Karate School Management Application (page 678 692) as a guide while you create your application. You are to create your own interface and make sure that you create each form as neat and self-explanatory as possible. 1. Recurring Specifications that are required for the Karate program 1. The form must be renamed and the title changed to reflect YourFirstName and YourLastName as Karate Queries by YourFirstName YourLastName. (If Pat Programmer was creating this program, it would be Karate Queries by Pat Programmer) 2. Code must be grouped and commented in compliance with this course's programming standards. 3. ALL files, forms, and controls MUST be renamed. 4. Option Strict and Option Explicit must be ON 5. ALL controls on the form must be in logical TabOrder using TabIndex in the Properties window for each control. 6. The text property of Labels must be changed so that Label1 (or similar name) does not appear at runtime. 7. Data types for variables and constants must be the most efficient. 8. Use With..End With if and when appropriate. 9. ToolTips 10. Various erroneous inputs will be tested during the grading process. If any of them result in the program halting of crashing, the maximum credit will be 50%. If submitted by the initial deadline, it may be resubmitted until the final deadline. Work that is late or resubmitted is subject to a 10% penalty, but that might be better than 50% or a 0 . 2. Connection Strings must not include absolute paths (paths to files on your computer... without modifications when they are graded. Program Grading Criteria Grading Chart

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Jay Greenspan, Brad Bulger

1st Edition

978-0764535376

More Books

Students also viewed these Databases questions

Question

1. What are the pros and cons of diversity for an organisation?

Answered: 1 week ago

Question

1. Explain the concept of diversity and equality in the workplace.

Answered: 1 week ago