3.1 The following refer to objects.
a. What are the benefits of creating a class?
b. What is the difference between a data member in a class and a property of a class?
c. What's an overloaded method?
3.2 The following refer to shared properties.
a. How does a shared property differ from an object instance property?
b. What uses are there for shared properties?
Module 4
4.1 Suppose we want to execute an SQL query against a particular database and display the results. Explain how each of the following objects would be used:
a. Connection
b. Command
c. DataReader
4.2 What are the differences between a DataSet and a DataReader?
4.3 ASP Datasets are disconnected. What are the practical effects, both good and bad, of this decision?
4.4 How can you update a database in an ASP page without using a DataAdapter?
Module 5
5.1 What are the advantages of ASP.NET server controls versus HTML server controls? Given those advantages, explain why HTML server controls should still sometimes be used.
5.2 What sorts of activities are commonly performed in the following events?
a. Page_Load
b. Page_Unload
5.3 The following refer to validation controls. You may need to reference the Class Browser and MSDN documentation to answer these.
a. What property tells you that input failed to validate?
b. What is the purpose of a validator's ErrorMessage property?
c. Can a single control be bound to multiple validators?
5.4 The following refer to data rendering controls.
a. What is the difference between a DataList and a Repeater?
b. What are some of the advantages of using a data rendering control versus simply writing code to display the contents of a recordset?
5.5 The following refer to states.
a. What kinds of data should be stored in the application state?
b. What kinds of data should be stored in the session state?
c. Why is it important to limit the amount of data stored in the application and session states?
5.6 What sort of data should be stored in a cookie?
INVESTMENT CALCULATOR 2.0
Create a class called Investment. This class should have properties for an investment amount, the year the investment started, and a percentage growth rate. It should also have a method which is passed a year and returns the value of that investment in that year. For example, after setting the initial investment amount to $10,000, the initial year to 1990, and the growth rate to 0.11 (representing 11%), calling this method with the value 1992 would return $12,321.
Modify your investment calculator so that the page has four text boxes, one for an initial investment, one for the initial year, one for the last year of the investment, and one for a percentage yearly growth rate, all properly labeled. When the user fills in all three boxes and clicks a button, the current value of the investment will be displayed.
* Make use of your Investment class.
* Add validators to the text boxes to force the user to enter valid values.
* Using cookies, have the program remember the values in the text boxes. That is, if the user types in numbers in all three boxes and clicks the button, the user can close the browser, reopen the browser and this page, and the last numbers entered should be in the boxes.
BOOKSTORE 2.0
Using the Northwind database, write a page that displays a list of all the shippers in a list box control. When a shipper is selected in the list, have the shipper's ID number displayed in a label.
To do this, set the list box's DataTextField to the company name (so we will see the names listed in the list box) but set the DataValueField to the shipper ID. Then when the list box index changes, you only need to display the value of the selected item.
Important note: your code should assume the Northwind database is located at C:BegASPNet11 data Northwind.mdb.
BOOKSTORE 3.0
Expanding the previous program, instead of displaying the shipper ID, display the order date and shipping address of all the orders for the selected shipper. Display the orders in a data grid control.