Cis407,Cis/407,Cis 407,Cis/407 Ilab 1 of 7,Cis407 Ilab 1 of 7,Cis 407 Ilab 1 of 7

1306 Words Jul 31st, 2014 6 Pages


---------------------------------------------------- ----------------------------------------------------

Cis 407a – ilab 3 of 7


In this lab, we will demonstrate how to save user activity data in a database. We will be creating a new form to display the user activity data, a new dataset to contain the data, a data access class to structure the code, and a function within the data access class to save users’ activity data when users visit the Personnel form page (frmPersonnel.aspx). We will also be adding server side validation to the frmPersonnel for you added in the previous lab and update or main menu for the new
…show more content…
You will also add a new item to frmMain that will take the user to the new frmUserActivity form you added. Add the proper link and a hyperlinked image to allow the user to select this new option. Once you have verified that everything works, save your website, zip up all files, and submit in the Dropbox.

i L A B S T E P S

STEP 1: Data Connection, Dataset and Data Access Class (10 points)

Open Microsoft Visual Studio.NET 2008.

Open the PayrollSystem website by clicking on it in the Recent Projects list, or by pulling down the File menu, selecting Open Website, navigating to the folder where you previously saved the PayrollSystem, and clicking Open.

Download the PayrollSystem_DB.MDB file from Doc Sharing and save it on your local computer. (Note: your operating system may lock or block the file. Once you have copied it locally, right click on the file and select Properties and then Unblock if available). Then add it to the PayrollSystem website as follows: In Visual Studio, in the Solution Explorer click Website, Add Existing Item, then navigate to the PayrollSystem_DB.MDB file you downloaded and click the Add button.
Now we need to create a new connection to the PayrollSystem_DB.MDB. To begin, click View Server Explorer.

When the Server Explorer toolbox appears, click the Connect to Database button.

When the Add Connection dialog appears, click the Change button. In the

Related Documents