Winform Set 04
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Winform Set 04 as PDF for free.
More details
- Words: 459
- Pages: 3
PRACTICAL EXAMINATION QUESTION PAPER Winforms Set 04
Semester: 3
Curriculum:
Date:
Duration:
2003 2 Hours
Total Marks: 30
Important to students Read carefully the following instructions before doing your work on the examination. Your work will NOT be accepted for evaluation UNLESS it conforms to all the instructions. -
Students must create a folder named in the specified location (e.g. d:\Online) and save all necessary files (including source, class, html, database, txt, ...) in the created folder, do not classify into sub-folders. All other locations will be ignored.
Winform Practical – Set 4
Page 1
1. Question Create a “UserManager” application with the following specifications: Create SQL Server Database name “UserManager” on LOCAL SQL-SERVER Student must generate the script of creating tables and write down script to insert data into tables. All scripts must be submitted in the file <Student Number>.SQL and save in the submitted folder. Given below is the “User” table structure to be used:
-
This application will consist of 3 Forms: form Login, form Main and form UserDetail. The interface of form Login is shown below: (5 marks)
-
This form checks the Username and Password if they match with the database. If the Username and Password are correct, the form Main will be opened. (3 marks) The form Login must be closed before the form Main is opened. (2 marks) The form Main must be a MDI parent form, it has a menu. The interface of form Main is shown below: (8 marks)
-
-
When the “View User” option on the menu is selected, the form UserDetail will be opened.
Winform Practical – Set 4
Page 2
-
The form UserDetail has a datagrid to displays user details, this form has 3 button used to update, reset user detail and to close the form. The interface of form UserDetail is shown below:
-
This form must be an MDI child form. (2 marks) If the login user has the Administrator right, he can edit user details in this datagrid, otherwise this datagrid is read-only and the button Update, Reset is disabled. (2 marks) When the user clicks on the button Update, all changes will be updated to the database. When the user clicks on the button Reset, all user details will be reset from the database. (2 marks) This form can be resized. When this form is resized the datagrid and all buttons will be resized and relocated associatively. (2 marks) The Column “UserID” must be read-only. (2 marks) Each value in column “Username” must be unique. (2 marks) When a row is added, application must generate a new UserID which is the next number greater than the current max ID. (2 marks)
-
-
Winform Practical – Set 4
Page 3
Semester: 3
Curriculum:
Date:
Duration:
2003 2 Hours
Total Marks: 30
Important to students Read carefully the following instructions before doing your work on the examination. Your work will NOT be accepted for evaluation UNLESS it conforms to all the instructions. -
Students must create a folder named
Winform Practical – Set 4
Page 1
1. Question Create a “UserManager” application with the following specifications: Create SQL Server Database name “UserManager” on LOCAL SQL-SERVER Student must generate the script of creating tables and write down script to insert data into tables. All scripts must be submitted in the file <Student Number>.SQL and save in the submitted folder. Given below is the “User” table structure to be used:
-
This application will consist of 3 Forms: form Login, form Main and form UserDetail. The interface of form Login is shown below: (5 marks)
-
This form checks the Username and Password if they match with the database. If the Username and Password are correct, the form Main will be opened. (3 marks) The form Login must be closed before the form Main is opened. (2 marks) The form Main must be a MDI parent form, it has a menu. The interface of form Main is shown below: (8 marks)
-
-
When the “View User” option on the menu is selected, the form UserDetail will be opened.
Winform Practical – Set 4
Page 2
-
The form UserDetail has a datagrid to displays user details, this form has 3 button used to update, reset user detail and to close the form. The interface of form UserDetail is shown below:
-
This form must be an MDI child form. (2 marks) If the login user has the Administrator right, he can edit user details in this datagrid, otherwise this datagrid is read-only and the button Update, Reset is disabled. (2 marks) When the user clicks on the button Update, all changes will be updated to the database. When the user clicks on the button Reset, all user details will be reset from the database. (2 marks) This form can be resized. When this form is resized the datagrid and all buttons will be resized and relocated associatively. (2 marks) The Column “UserID” must be read-only. (2 marks) Each value in column “Username” must be unique. (2 marks) When a row is added, application must generate a new UserID which is the next number greater than the current max ID. (2 marks)
-
-
Winform Practical – Set 4
Page 3
Related Documents
Winform Set 04
November 2019 1
Winform Set 02
November 2019 0
Winform Set 01
November 2019 0
Winform Set 03
November 2019 0
Winform Set 05
November 2019 0