Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare the project below. Only write the action performed methods for the buttons. You can make use of a model class for contacts. Database name

image text in transcribed

Prepare the project below. Only write the action performed methods for the buttons. You can make use of a model class for contacts. Database name will be MyCompany and the table is Contact. Database connections should be created accordingly.

1 (20pts) When this button is clicked, all the contacts from "Contact" table of the database named "My Company" will be retrieved and shown in the table. Contacts Contact List Get List ID Name Surname Phone E-Mail 1 Eric Hall 0533234541 erich@gmail.com 2 Lisa Gray 05379808766 lisag@gmail.com 3 Lucy Melli 05329871122 lucym@xyz.com 4 Tom Fatty 05443421278 tomf@hotmail.co... 5 Dan Tims 05543246578 timsd@abc.com 6 Joe Roll 05457658778 joeroll@gmail.co... 2 (20pts) When this button is clicked, selected contact or contacts will be deleted from 'Contact table in 'MyCompany database without creation a new contact. Be careful that multiple number of contacts can also be deleted with this button. Contacts should be deleted from table as well. New Edit Delete Exit When this button is clicked, "New Contact page will be opened and with the "Save' button in it, a new contact will be created and saved into Contact table in 'MyCompany database. When this button is clicked, 'Edit Contact page will be opened and with the "Save' button in it, selected contact from itable will be edited and saved into 'Contact' table in 'MyCompany' database without creating a new contact 3 (30pts) 4 (30pts) IX New Contact Edit Contact ID ID Name Name Dan Surname Surname Tims Phone Phone 05543246578 E-Mail E-Mail timsd@abc.co Save Save 1 (20pts) When this button is clicked, all the contacts from "Contact" table of the database named "My Company" will be retrieved and shown in the table. Contacts Contact List Get List ID Name Surname Phone E-Mail 1 Eric Hall 0533234541 erich@gmail.com 2 Lisa Gray 05379808766 lisag@gmail.com 3 Lucy Melli 05329871122 lucym@xyz.com 4 Tom Fatty 05443421278 tomf@hotmail.co... 5 Dan Tims 05543246578 timsd@abc.com 6 Joe Roll 05457658778 joeroll@gmail.co... 2 (20pts) When this button is clicked, selected contact or contacts will be deleted from 'Contact table in 'MyCompany database without creation a new contact. Be careful that multiple number of contacts can also be deleted with this button. Contacts should be deleted from table as well. New Edit Delete Exit When this button is clicked, "New Contact page will be opened and with the "Save' button in it, a new contact will be created and saved into Contact table in 'MyCompany database. When this button is clicked, 'Edit Contact page will be opened and with the "Save' button in it, selected contact from itable will be edited and saved into 'Contact' table in 'MyCompany' database without creating a new contact 3 (30pts) 4 (30pts) IX New Contact Edit Contact ID ID Name Name Dan Surname Surname Tims Phone Phone 05543246578 E-Mail E-Mail timsd@abc.co Save Save

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

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago