Instructions
This assignment doesn't require any Visual Basic code, but don't worry, we are going to make up for it two assignments from now when we will write a lot of code.
First, Get the Community Assist database. Instructions for installing the database are on the Community Assist page
Start a new Web Site
On the default page add two GridView controls. Format them as you wish
Use the wizards to bind the Grids to a data source. Create a new connection to the ".\sqlexpress." Use the Community Assist database. The first grid should be bound to the Person table. Enable Select and paging on the Grid.
The second Gridview should be bound to the Address table. Add a where clause that gets the PersonKey from the first grid and uses it as a criteria for the second grid. When you select a person in the first grid, the second grid should show the person's address. Under Advanced have it generate update and insert and delete statements. Enable optimistic concurency. Finally enable updating in the grid.
Run the program. Update Bob Carmel's Address to be 2130 student
Turn in the source code. Confirm the update by just letting me know if it was successful or not.
Grading
The assignment is worth 10 points
- 4 points for the first grid and datasource
- 4 points for the second grid and datasource
- 2 points for updating the record