Microsoft ASP.NET
Using Databases exercise
Relatively easy
This Microsoft ASP.NET USING DATABASES exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ASP.NET 2.0 USING C# course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Choosing prime minister from drop down list
A full answer to this exercise is provided as part of the training course!
| 1) | Create a new database (in SQL Server Express, probably) called PrimeMinisters. |
| 2) | In this database, create a new table containing two fields:
|
| 3) | Enter a few plausible-sounding future prime ministers in the table. |
| 4) | Create a new web form containing a drop down list, which allows you to choose your candidate for the next prime minister: |
Wise Owl nominations for the job are shown here
|
|
| 5) | Attach code to the OK button such that when a user clicks on it, the choice made is shown on screen. If no choice has been made the SelectedValue property of the DropDownList will be 0, and you should display an error. |
| 6) | Save and close down any files that you have open. |
Thank you for showing an interest in this ASP.NET 2.0 using C# training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
