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

Ask an Expert

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

Write your message here..

Related Questions

Package body in pl/sql, Package Body: The package specification is imp... Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

Records - syntax, Records Records are the items of the type RECORD. The... Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

Sql is a database language, SQL Is a Database Language: The commands g... SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

Triggers, At times, customers make mistakes in submitting their orders and ... At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Parameter default values, Parameter Default Values As the illustration ... Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

%found - explicit cursor attributes, %FOUND Subsequent to a cursor or ... %FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Application to export excel data to mssql server table, Application to Expo... Application to Export Excel Data to MSSQL Server table I am having a table available in excel format and features the subsequent: - Some text is in Arabic (e.g. UTF-8 encodin

Boolean values-assignments in pl/sql, Boolean Values Only the values TRU... Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

Need to change mysql query to pdo, Need to change mysql query to PDO Pro... Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

Origin of earth - big bang hypothesis, ORIGIN OF EARTH - BIG-BAN G HY... ORIGIN OF EARTH - BIG-BAN G HYPOTHESIS - Origin of life is linked to origin of earth. Cosmos, the Universe originated 10-20 billion years ago by Big Bang (thermonu