Assume we have Employee table as given below,     

 Develop a “Window Form Application” in C# to fulfill the functionality of given below form. Functionality of each button is explained below

i) Add Employee button will add new employee in DB with unique ID.

ii )Delete and Update Employee will be on the basis of employee ID.

iii) Retrieve All Employee button will retrieve all employees from DB table and populate into grid view control.

iv) Update Employee will update the existing employee; it Search employee on the basis of its ID.

Apply Exception handling in the code and Before the Employee Record is Saved to Database, apply the following Data Validation Checks

1. ID should be distinct and it should not be duplicated in the Table

2. ID, Name, Designation and Salary should not be null

3. ID and Salary should be non-negative, greater than Zero and Positive Values

4. Name and Designation Length should be greater than 6 Characters and Name should not contain any Digit (0-9)

5. Before any DML Statement is executed (Insert Into, Update or Delete), Ask User using MessageBox whether He/She really want to Add / Update / Delete the Record. When user press the OK button on the MessageBox then Record DML statement should be executed

ID int Name varchar (50) Designation varchar (50) Salary int