Personnel Database Use Visual Studio (2010 or 2012) C# , to create a database na

Question

Personnel Database

Use Visual Studio (2010 or 2012) C#, to create a database named Personnel.mdf. The database should have a table named Employee , with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table. Create an application that displays the Employee table in a DataGridView control.

Please, reply with a link to download completed project file; you can upload file at, https://www.dropbox.com/home, then reply with the share link, to download the completed project.

Explanation / Answer

replace PROCEDURE get_employee_info_by_employee_id
(e_id NUMBER NULL)
AS
BEGIN
This cursor will return
- a single row if e_employee_id is specified in the table
- all rows in the table if e_employee_id is NULL and exists in table
- all rows in the table if e_employee_id is specified but does not
exist in the table

FOR Row IN (SELECT e_id, Name,e_Address, Hire_Date, Update_Date
FROM Employee WHERE e_id = p_id OR p_id IS NULL OR
0 = (SELECT COUNT(*)
FROM EMPLOYEE WHERE e_id = p_id)
LOOP
OUTPUT.PUT_LINE('Employee ID: ' || aRow.e_id);
OUTPUT.PUT_LINE('NAME: ' || aRow.NAME);
OUTPUT.PUT_LINE('EMAIL_ADDRESS: ' || aRow.EMAIL_ADDRESS);
OUTPUT.PUT_LINE('HIRE_DATE: ' || aRow.HIRE_DATE);
OUTPUT.PUT_LINE('UPDATE_DATE: ' || aRow.UPDATE_DATE);
END LOOP;
END get_employee_info_by_e_id;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.