Wednesday, July 11, 2007

ASP.NET Data Adapter and Reader

A. Place two buttons on the form labeled “Data Adapter” and “Data Reader”
B. Place a listbox on the form
C. On the click of the Data Adaper - fill the list box with the Company Names
from the Northwind customers table
1. Do NOT use data binding to do this…Must use a loop
D. On the click of the Data Reader - fill the list box with the Company Names
from the Northwind customers table
1. Do NOT use data binding to do this…Must use a loop
E. Print results and code.
F. Highlight the loops you create.
3. Add a page called Customers
A. Place a drop down list (customers) and a grid (orders)
B. Populate the drop down list with all the Company names in the Customers
table
C. On selecting a different customer populate the grid with the orders for that
customer displaying the following fields
1. OrderID, OrderDate, ShippedDate
2. Sort the list by OrderDate
3. Format the dates
D. Extra Credit
1. Include Employee Name who made the order.
E. Print the running page with three examples of different customers
F. Print code.
4. Add Players Web Page
A. Manually create a players table and add to a data set as follows (see help
Data Table Class… all the code is right there.)
1. PlayerID = Autoincrement field, seed and start values = 1
2. PlayerName = string
3. HireDate = date
4. Rank = Int
B. Add at least three rows.. Each with different data
C. Bind to a grid and display.
5. Format the HireDate on the gird but can not change the datatype of the
column in the dataset.