Reference no: EM131729498
Scenario/Summary
In this lab, we will start with the form that we created in Week 2 (frmPersonnel) and add functionality to INSERT records into a database table and SELECT records for display to the user. We will create a typed dataset, a Data Layer class, several functions to access the data, and a connection to a database.
We also will add a search form to allow the user to search records in the database and display the results of that search.
Please watch the tutorial before beginning the Lab.
Transcript
Deliverables
All files are located in the subdirectory of the project.
The project should function as specified: When you press the Submit button in frmPersonnel, a record should be saved in the tblPersonnel table having the FirstName, LastName, PayRate, StartDate, and EndDate that you entered on the form.
Add a search feature to the project.
Update your main navigation page with the new options. Once you have verified that it works, save your website, zip up all files, and submit it.
|
Construct a query that will show the number of days
: Construct a query to show the expected payment date if invoices are due within 30 days of transaction.
|
|
Describe three human resource factors that affect project
: Describe the different organizational structures as it relates to project management (i.e., functional, project-based, matrix).
|
|
How you would study the topic using the scientific method
: What are some of the pros of the method you chose? What are some of the limitations, challenges, and/or problems inherent in the method you selected?
|
|
Discuss about the cbs news survey
: In a CBS News survey done in 2009, 95% of n = 346 randomly sampled married men said that they would marry their spouses again if they had it to do all.
|
|
Create a typed dataset and a data layer class
: INSERT records into a database table and SELECT records for display to the user. We will create a typed dataset, a Data Layer class, several functions.
|
|
Difference between the sample proportions for men and women
: In a survey of college students, 70% (.70) of the 100 women surveyed said that they believe in love at first sight, whereas only 40% (.40) of the 80 men.
|
|
Determine how much cash was paid on accounts payable
: Total purchases on account during October were $281,000. Determine how much cash was paid on accounts payable during October
|
|
Prepare a cost of goods manufactured schedule for quarter
: Prepare a cost of goods manufactured schedule for the quarter, Prepare a cost of goods sold schedule for the quarter
|
|
Why are information systems vulnerable to destruction
: What are the components of IT infrastructure?Define information technology (IT) infrastructure and describe each of its components.
|