To Exam Info
Review Guide for Final Exam
Bring to Final
- Two pages (both sides) of notes.
- Copies of four examples of your choice. Here are the recommended
examples: Example 49 (grocery-display2.aspx),
Example 55 (grocery-display4.aspx), Example 60 (repeater.aspx),
Example 65 (seeds2.aspx),
- Table of Hex Digits
- Conversion Table for Base-64
Study for Final
- Review questions for each lecture, examples on the examples page,
source code for projects, sample midterm problems from the
Final Review Questions.
Know for Final
- HTML Tags:
<html>
<head>
<title>
<style>
<link />
<body>
<p>
<h1>
<h2>
<h3>
<ul>
<ol>
<li>
<table>
<tr>
<td>
<img />
<a>
<div>
- CSS Styles:
font-family
font-size
font-weight
font-style
color
background-color
text-align
vertical-align
text-decoration
font-family
float
- CSS Classes: Know how to define and use
CSS classes. Be able to use the CssClass property for controls.
- Hex Color Codes: Be able to tell which
one-byte hex value out of two is larger. Be able to convert an
rgb decimal color code (e.g., rgb(255, 128, 128)) to a hex color
code (e.g., #FF8080) or vice-versa.
- Classes and Objects:
Difference between class and object, constructor, property, method, event,
static property, static method, instantiate, class testing, UML diagram.
- Namespaces: Know how to include these C# namespaces
to avoid fully qualified names: System.IO, System.Data,
System.Data.Ole, System.Data.Drawing.
- Be able to write code to test properties and methods from these classes:
Color, DateTime, Random, string, StreamReader, StreamWriter. See the corresponding
UML diagrans on the UML Examples Page.
- ASP.Net Projects:
.aspx file, Web.config file, Code-behind file.
- Visual Studio Windows: Design window, source window,
code-behind window, Toolbox, Solution Explorer, Properties Window,
Dynamic Help Window, Web.config.
- C# Language Terms: Camel casing, Pascal casing, Hungarian notation,
tructured programming, structured programming.
- C# Constructions: if-else statements, while loops, for statements,
arrays.
- ASP.Net Controls:
Controls in General: Properties: AutoPostBack, BackColor,
BorderColor, BorderStyle, Enabled, Font-Bold,
Font-Name, Font-Italic, Font-Size, ForeColor, ID,
ToolTip; Method: Focus.
AccessDataSource: Properties: DataFile, SelectCommand.
Button: Properties: No AutoPostBack needed; Text;
Event: Click.
DataGrid: Property: DataSource;
Method: DataBind.
Literal: Property: Text, general properties do not
apply, go by CSS styles in effect; No Events.
Image: Property: ImageUrl; No Events.
Label: Property: Text; No Events.
TextBox: Properties: MaxLength, ReadOnly, TextMode;
Event: TextChanged.
RadioButton: Properties: ButtonGroup, Checked;
Event: CheckedChanged.
RadioButtonList: Properties: Items, SelectedIndex,
SelectedItem, SelectedValue; Event: SelectedIndexChanged.
CheckBox: Property: Checked; Event: CheckedChanged.
CheckBoxList: Properties: Items, SelectedIndex,
SelectedItem,
SelectedValue; Event: SelectedIndexChanged.
DropDownList: Properties: Items, DataSource,
DataTextField, DataValueField, SelectedIndex, SelectedItem,
Selectedvalue; Event: SelectedIndexChanged
Page: Properties: Application,
IsPostBack, Request, Response, Session;
Event: Load.
Repeater: Templates: HeaderTemplate, ItemTemplate,
AlternatingTemplate, SeparatorTemplate, FooterTemplate.
Table: Property: Rows.
TableCell: Property: Text.
TableRow: Property: Cells.
Posting an ASP.Net page back to itself.
File Input: Know how to create and use a StreamReader object
to read from a text file in the Database folder. StreamReader methods:
Close, Peek, ReadLine, ReadToEnd.
File Output: Know how to create and use a StreamWriter object
to write to a text file in the Database folder. StreamWriter methods:
Close, Write, WriteLine.
Appending to a File Know how to use the
StreamWriter constructor with signature (string, bool) so set up the StreamWriter
to append data to the end of a text file in the
Database folder.
Know how to use the string Format method to round a double value
to a specified number of digits behind the decimal point.
Session and Application Collections Be able to describe the purpose
of the Session and Application objects and some examples of where they would be used.
Cookies Know how to store and retrieve cookies.
Know how to compose SQL SELECT, INSERT, UPDATE, and DELETE statements,
both constant statements, and statements taking their values from
variables or controls.
Know what a join is and how to write an SQL statement to form a
two table join.
Know how to use the Connection, Command, DataAdapter,
and DataSet objects to access or modify the information in database tables.
Know how to use Connection and Command objects with SQL to
insert, update and delete information from database tables.
Be able to convert rgb color codes to hex color codes and vice versa.
Be able to convert hex numbers to base-64 and vice versa.
Know the difference between an ArrayList collection and a standard
array.
Be able to move data from one ASP.Net location to another, including
controls, arrays, an ArrayList collection, text file on disc,
databases. Know how to access data in
the DataSet object directly and using data binding.
Also be able to use Response.Write to display information.
Know what master pages are and how they can reduce the amount
of code on Web pages.
Be able to create an ASP.Net file containing both HTML and C# code that
solves problems similar to the problems in the Practice Midterm Questions
(to be discussed on Wednesday, February 3).
Be able to do on a computer using Visual Studio or notepad:
- Write CSS styles and classes.
- Test properties and methods from the classes listed on the
UML Examples Page.
- Submit an HTML form using the form action and method attributes.
Read the form data using Response.Params.
- Copy data from one location to another. The possible
data locations are:
Controls
variable
array
arraylist
session collection
text file
database table
cookie
Know how to use databinding for data bound controls.
Find the average of a list where the data is taken from
one of the data locations in c above.
Sort data in an array or arraylist.