program for employees -ado.net framework , PL-SQL Programming

Challenge 1

You are required to do the project and write a test plan for it.

Demo 4 is a check writer program for employees. In it, the user enters all information about the employees. You are to modify it so that the information comes from the Danco database (I have given you both a SQL Server and an Access version)

When the program starts, the user chooses between Salaried and Hourly

If the user picks Salaried, a combo box with all Salaried employees appears Employees are sorted in alphabetical order by last name.

Salary initially displayed is retrieved from the database. User can change the Salary and then write the check. (Unless you are working for extra credit, there is no need to write changes back to the database.)

If the user picks Hourly, a combo box with all Hourly employees appears Employees are sorted in alphabetical order by last name.

Hours and Rate are initially displayed is retrieved from the database.

User can change Hours and Rate and then write the check. (Unless you are working for extra credit, there is no need to write changes back to the database.)

Assume that an Employee in the database is Salaried if the Salary field is greater than 0; otherwise, they are Hourly.

You must use ADO.NET. 

You can data bind if you want (I did), but it's not required.

My advice: Just work on Salaried employees first.

Then comment out the code and just work on Hourly employees.

Then get the program to work together.

Challenge 2

Roll your own

Create an application that uses a 2 or 3 tier application,

Using a database and the ADO.NET framework

(either DataReader or DataAdapter)

Create the SQL Server or access database

Create a UML diagram

Create a test plan.

What it does is up to you.

Points given for originality. 

(It can't just be a slight rehash of a prior week's assignment.)

If you want to do this part, please run your idea by me first so I can:

-   Tell you if it's sufficient for the assignment

-    Advise you if it's way too much to accomplish in a week.

You can earn up to 25 points extra credit for this lab, provided the idea is original enough

Posted Date: 2/18/2013 3:16:54 AM | Location : United States







Related Discussions:- program for employees -ado.net framework , Assignment Help, Ask Question on program for employees -ado.net framework , Get Answer, Expert's Help, program for employees -ado.net framework Discussions

Write discussion on program for employees -ado.net framework
Your posts are moderated
Related Questions
Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

LAWS / RULES - Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible. Williston's Law

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know

Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE