Question: DONE IN C# CONSOLE making calls to MYSQL Start a new project in Visual Studio called db_14 and add the MySQL reference. Prompt the user

DONE IN C# CONSOLE making calls to MYSQL

Start a new project in Visual Studio called "db_14" and add the MySQL reference.

Prompt the user to enter a username and password then call login.

Call display to show the object properties.

If the user is not found display "Invalid Login" and exit.

Else, prompt the user to enter in the fields for the user object. (Firstname, Lastname, username, password...)

If the user enter a blank, use the existing value from the object.

Save the object to the database,

Call display to show the object properties.

Manually, go to Sequel Pro and check the database to ensure the update occurred.

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!

Q:

Pharoah Company shows the following balances in selected accounts of its adjusted trial balance. Supplies $35,840 Supplies Expense 6,720 Accounts Receivable 13,440 Dividends 24,640 Retained Earnings...

Q:

THIS WILL BE WRITTEN IN C# PLEASE INCLUDE DATABASE DUMP AND INFORMATION FROM MYSQL; PLEASE DO NOT NOTEPAD YOUR ANSWER. I CANNOT SEE OR READ WRITING. PLEASE INCLUDE ALL RELEVANT CODE TYPED. PLEASE...

Q:

THIS WILL BE WRITTEN IN C# PLEASE INCLUDE DATABASE DUMP AND INFORMATION FROM MYSQL SEE OTHER CHEGG PROBLEM HERE:...

Q:

The instruction is below. The ImageLib.h and ImageLib.lib are code for an image provided by the instructor. C++ LANGUAGE Here is the code that I've done so far. #include #include "ImageLib.h" //...

Q:

I've done the instructions until 7b, and the e-g. I just need help with 7c which is the mirror image. here is my codre #include #include "ImageLib.h" // forward declarations void newImage(image in);...

Q:

IN C++ PLEASE! Lab Week 4 User Defined Functions and include files Skills Required Create Functions Include Headers and other files Loops (while, for), Conditional (if, switch), Datatypes,...

Q:

Lab Exercise 2: C\# .NET 6 Class Library For exercises 24, create a blogging site using ASP.NET Web API and SQL Server Database. The site must have log in, registration, and post functionality...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

C# PROJECT Story 1 - Create the Project Create a new console project to hold your code. Description For this first lab here are the directions. Note: These instructions assume you are using the Git...

Q:

C# PROJECT Story 1 - Create the Project Create a new console project to hold your code. Description For this first lab here are the directions. Note: These instructions assume you are using the Git...

Q:

11:10 Search Back Assignment1.docx In Assignment 1, you will design and implement code to (1) display the player ship and the region of space in front of it, (2) move the player ship, and (3) detect...

Q:

Consider a manufacturer who operates 24 hours a day, 5 days a week. To accommodate a 24-hour work day, the plant operates three shifts (A,B, and C). As is typical in industry, production volumes tend...

Q:

The following three entities make up an economic group as follows: Apple Ltd purchased 60% of the shares totalling $65,000 in Banana Ltd and Banana Ltd wholly owns Cherry Ltd which was purchased for...

Q:

Suppose one of your clients is looking for a $ 7 6 , 1 3 0 fully amortize loan with 9 % APR interest to buy a Mobile home. If she is only committed to paying $ 7 0 9 per month toward paying off the...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

5. Do you receive an equal number of opinions, feelings, and suggestions from all employees?

Q:

Develop a detailed action plan to achieve this vision, and make commitments for particular actions necessary to bring your vision to fruition.

Q:

How would you describe your typical day at work?