To Lecture Notes

IT130 Notes -- 5/27/09

Review Questions

1. Write an SQL statement that will insert this row into the Persons table: name=William, gender=M, age=26. Ans:

   INSERT INTO Persons VALUES ('William', 'M', 26);
   

2. Write an SQL statement that will delete all women from the Persons table younger than 21. Ans:

   DELETE FROM Persons WHERE Gender= 'F' AND Age < 21;
   

3. Write an SQL statement that will subtract 5 from the ages of everyone named Fred. Ans:

   UPDATE Persons SET Age = Age - 5 WHERE Name = 'Fred';
   

More about CSS

• div tags
   
• See Example 52 (absolute.htm).
   
• The float property.
   
• See Example 53 (float.htm)
   
• Use Visual Studio to write CSS styles and classes.
   
• A list of HTML language codes.
   
• Although the lang attribute does not directly affect how browser renders the text of the page, it may be used in the following ways:
   
  
  Assisting search engines
   
  Assisting speech synthesizers
   
  Helping a user agent select glyph variants for high quality typography
   
  Helping a user agent choose a set of quotation marks
   
  Helping a user agent make decisions about hyphenation, ligatures, and spacing
   
  Assisting spell checkers and grammar checkers
   
  
• A class is like a style with a user defined name.
   
• The class definition in a document-style or external style:

  .tt   { font-family:Lucida Console;
          font-weight:bold; }
  

• Using a class:

  The nonbreaking space symbol: 
  <span class=tt>&amp;nbsp;</span>.
  

Accessing Data in a DataSet Object

• Each DataSet object contains a Tables collection.
   
• Each Tables collection contains DataRow objects.
   
• Each DataRow object contains an ItemArray array.
   
• Each ItemArray contains objects of class object.
   
• The ToString method converts objects of object class to class string.
   
• See Example 57 (dataset-direct1.aspx).
   
• Modify Example 57 so that the Price and Quantity are displayed in textboxes when the item name is entered in a textbox.

Data Binding Controls

• Here are some ASP.Net Web controls with databinding capability:
   
  
  DataGrid   DataList   DropDownList   RadioButtonList   GridView   Repeater
  
  
• See Example 64 (states.aspx).

The Repeater Control

• A Repeater control is a high-performance, light-weight control that allows a great degree of flexibility for formatting read-only data from database tables.
   
• See Examples 60 (repeater.aspx) and 64 (seeds1.aspx).
   
• Advice: for IT230, use a repeater control for formatting data from a database that is intended to be read-only. Code the controls on the webpage by hand or with Visual Studio if you want to use them to input data to a database.
   
• The DataGrid control has more capabilities than the Repeater control. Use it if you want CRUD capability (create, read, update, and delete).

The AccessDataSource Control

• The AccessDataSource control is simpler, but less flexible, than using the Connection, DataAdapter, Command, and DataSet objects.

• See Example 61 (persons-display.aspx).