To Lecture Notes

IT130 Notes -- 5/20/09

Review Questions

1. Give four different ways of marking source code comments in an .aspx file. Ans:
   

   <!-- This is a client-side HTML comment. --%gt;
   
   <%-- This is a server-side comment. --%>
   
   // This is a C# or JavaScript comment.  
   // The whole line is commented out.
   
   /* This is a CSS comment
      It also works in C# and JavaScript. */
   

2. Give three methods of an ArrayList control.
   Ans: Add, Insert, RemoveAt
    
3. Copy the 12th item of the ArrayList control col to the TextBox object txtDisplay.

   txtDisplay.Text = col[12];
   

4. Write the ASP.Net XML code for this Table object:
    
   

   abc	def
   hij	klm

   <asp:Table ID=Table1 runat=server>
       <asp:TableRow runat=server>
           <asp:TableCell runat=server>abc</asp:TableCell>
           <asp:TableCell runat=server>def</asp:TableCell>
       </asp:TableRow>
       <asp:TableRow runat=server>
           <asp:TableCell runat=server>hij</asp:TableCell>
           <asp:TableCell runat=server>klm</asp:TableCell>
       </asp:TableRow>
   </asp:Table>
   

5. Write C# code that will append the text in Row 1, Column 0 of the table in Problem 2 to the literal control litDisplay.
   

   litDisplay.Text += Table1.Rows[1].Cells[0].Text;
   

More SQL Statements

• The Insert Command. Example:

  INSERT INTO Persons VALUES ('Alice', 'F', 25);
  

• The Delete Command. Example:

  DELETE FROM Persons WHERE Name = 'Alice';
  

• The Update Command. Example:

  UPDATE Persons SET Age = Age + 1 WHERE Name = 'Alice';
  

More Database Examples

• Look at Examples 63 and 65.

Practice Problem

• Write an ASP.Net application that will take a credit card number from a textbox and the quantity of umbrellas to order from a dropdown menu and write the following information to a table in a database: credit card number, current date and time, total order.
  Ans: umbrellas-aspx.htm.