Using this attendence project, Answer

Visual Programming, C# and SQL

Question no 1 (13) Create the following SQL Project and code according to the given Employee Registeration Form. Apply proper regular expression checks. Pattern should be like this: CNIC: 33102-9918283-7 Employee Name: Maira Khalid (First and last letter capital) Gender: Not Null DOB: mm-dd-yyyy Email: abc@gmail.com Address: Combination of characters and limit is 50 City: Combination of characters and limit is 20 Contact No: Only Numeric and 11 characters Register the data and create appropriate DB. Employee Registration 0 Employee Registration Employee Name Abdul Rahman CNIC 33102-9918283-7 Gender O Male Female Email abc@gmail.com Mobile # 03217807470 DOB 10/15/1989 Join Date 8/28/2014 fsd Address fsd City Account status o Active Job type Permanent Browse Picture Emp type Teaching staff Save Update Delete Card view Scan Finger Save Finger Deactive Name CNIC Gender Muhammad Umar 33102-3450567-0 Male Abdul Rahman 33102-9918283-7 Male Mudassir Manz. 33202-4432413-9 Male Umar 33333-3333333-3 Male Zohaib 444444444444-4 Male Ateeq 555555555555-5 Male Status Active Active Active Active Active Active Mobile 1212 123 12345 123 123 123 Email DOB Joining Job Type and@gmai.com 8/29/2014 8/29/2014 Permanent abc@gmail.com 8/28/2014 8/28/2014 Permanent asd@gmail.com 8/29/2014 8/29/2014 Permanent abc@gmail.com 8/28/2014 8/28/2014 Permanent abc@gmail.com 8/28/2014 8/28/2014 Permanent abc@gmail.com 8/28/2014 8/28/2014 Permanent Emp Type Non teaching Teaching staff Teaching staff Teaching staff Teaching statt Teaching staff Today is: Friday Date: 09/19/2014 | Time: 21:14:48 Question no 4 (13) These are the given buttons in above Attendance Project. (a) Write a piece of code that will browse Picture. (b) Write a piece of code that will save picture path. (c) Display Message after successful saving Browse Picture