Create a simple C# application that connects to an existing database and provides the user with the ability
to interact with the database through a graphical interface. You must use the Windows Forms framework
for creating the Graphical User Interface (GUI) for this C# application.
[login to view URL]
An existing SQL database file named [login to view URL] is provided above as an attachment to this test. This
database contains a table named Employee with four columns: Employee ID, Name, Position, and Hourly
Rate. You are required to create a C# application that connects to this database and allows the user to do
the following tasks:
Detail
The application needs to have two forms according to the following criteria:
• The application’s 1
st form should display the Employee table in a DataGridView control. It should
have a
1. Close button
2. Two Textbox for search with descriptive labels above them:
a. The user can enter any part of a name in the first Textbox
b. The user can enter a payrate in the second Textbox. The search should return any
payrate greater than the entered payrate.
3. A Search button: when it is clicked the result of the search is shown in the DataGridView control.
The search criteria is “the criteria entered in the first Textbox” AND “the criteria entered in the
second Textbox”
4. Average pay rate Button: clicking it will show the average pay rate of all employees in a message
box
5. Detail View: when it clicked the second form is shown with the following specification:
• The application’s 2
nd form should display the employee name in a combo box (one name at a time)
and the pay rate for that employee in front of it an appropriate control object. The user can not
modify the name or the pay rate in the second form. The second form should also contain a Close
Button.
Good day, I can Help you with "Create a project with C# application"
I can start working immediately if you give me a Go!!!
★★ EXPERTISE SKILLS ★★
Software Engineering