Zoom
be reloaded.
(1.5 point) When user selects a row in the datagridview, load data of corresponding employee into controls in [Action] groupbox. User can use Update and Delete button for updating and deleting information of this employee in database. The data of datagridview must be reloaded.
Question 3. (2 points)
You are asked to write a Webform application that show information about contracts in database. (0 will be given to the work that not using database connection string in appsettings.json). In this question, you must use ADO.NET to connect database.
List of contracts
Select customer
Code
Customer
Employee
Type
SignedDate
HD01-08/21/1
Nguyen Bao Trung
Nguyen Bao Trung
Consultation
04/01/2021
HD02-09/21/1
Nguyen Bao Trung
Nguyen Phuong Thao
Consultation
05/02/2021
HD03-09/21/7
Nguyen Phuong Thao Nguyen Phuong Thao
Nguyen Bao Trung
Deployment
12/01/2020
HD04-09/21/1
Nguyen Phuong Thao
Deployment
12/06/2020
HD05-09/21/3
Nguyen Phuong Thao
Tran Thu Nga
Consultation
07/12/2019
HD06-09/20/1
Nguyen Bao Trung
Tran Thu Nga
Deployment
15/04/2021
HD07-10/21/1
Tran Thu Nga
Nguyen Bao Trung
Deployment
30/03/2020
Figure 1 - Required page
The page is designed as shown in Figure 1.
(0.5 point) Load all customers from database into the dropdownlist. Add one more item "Selectcustomer" in this list.
Select customer
Select customer
Nguyen Bao Trung
Nguyen Phuong Thao
Tran Thu Nga
Figure 2- Options of the DropDownList
(1 point) List all contracts from database into table below.
+ 100%
Close
