CS 432

Assignment 3

ASP.NET

Out 2/21/2008, Due 2/28/2008

 

Objective(s)

1.      To use the object data source

2.      To customize the grid view control

3.      To use Themes and Skins to format the page

 

Turn in

1.      This sheet

2.       Screen shots

3.       Your code

 

Create a web-enabled application using ASP.NET as described:

  1. Create a database table Cars – for a car dealership. In your database, have 10 cars: car id, make, model, year, description, and price.
  2. Create a database table CurrencyExchange: regionid, region, currency, exchange. This table will store the currency rate for that region. Have at least 3 regions (e.g., North America, Europe, Japan). Here is an example table:

 

RegionID

Region

Currency

Exchange

1

North America

USD

1

2

Europe

EUR

0.68

3

Japan

JPY

108

 

  1. The user interface will consist of a dropdown control along with a button. This control will be populated with the different regions – use object data source.
  2. The user will first select a region and then click the button.
  3. At this point, use an object data source to populate a grid view. The price of the cars should be displayed in the currency of the region selected.
  4. Use Themes and Skins to format the server controls.

 

Graduate Students

Enhance the application to include such things as:

  1. Add insert, update, delete, events to the object data source so that the dealer may modify data in the database.