Question: 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!!!Please HELP me in Visual Basic!!! Please provide me VB code andalso the design if you have it too. I will thump upif your answer help!!! Objectives 1. Create VB applications that use databases.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!