Final Assignment

1. download the Student DB and place it in your app_data folder
2. For the two pages you create, UNCHECK the box that reads "place code in separate file"
3. Create a page that has a dropdown list box list all the courses (courses table): show the description but the value is the CourseID. call this page mainpage.aspx
4. When I click on a course in the drop down list box (check Autopostback), I will see a gridview of all the employees enrolled in that course. Use the query builder to create a relational query between the Enrollments and the Employees tables. Watch the video in Chapter 8 to learn this!
5. This gridview is editable. I can change the employee information in the gridview. Just employee info, nothing else.
6. At the botton of the page, have I link to Add a new Employee (EmpAdd.aspx) (a link that takes me to another page with a detailsview in InsertMode). Focus should be on first field. After it's done inserting to the db, redirect me back to the mainpage.aspx. Hint: put response.redirect "mainpage.aspx" in the EVENT ItemInserted of the DetailsView control

Email me the two files: mainpage.aspx and empadd.aspx by 8AM Wed May 31.

That's It If you have any Questions just Email me at