To ExamInfo

Bring to Midterm: Textbook. The exam is open book and open notes. Bring a calculator if you wish, but you probably won't need it.

Read in the Textbook:

Chapters 1, 3 to 8, 10. Read about the controls ListBox and ComboBox only in Chapter 9.

1. The .NET IDE: IDE, Solution Explorer, Console and Windows Applications, Properties Window, Code Window, Form Designer Window, Toolbox, Dynamic Help, Intellisense, Startup Object.

2. Object Oriented Concepts: Module, Class, Object, Property, Method, Event, Event Handler, Reference Variable, Constructor, Nothing

3. VB.NET Language: Namespace, Imports, Constant, Variable, Datatype (Integer, Double, String, Boolean), Arithmetic Operator (+, -, *, /, \, ^, Mod), Concatenation Operator (&), Comparison Operator (=, <, <=, >, >=, <>), Logical Operator (And, Or, Not), Assignment Operator (=, +=, -=, *=, /=, ^=, &=), Control Structures (If, While, For, Select), Builtin Methods, User Defined Methods: Subroutine (no return value), Function (returns a value), ToString Function, Shared Method (a method that is called from a class or module, not from an object).

4. The String Object: 4 methods of creating a string, Property (Length), Methods (ToUpper, ToLower, Substring, Trim, IndexOf, IndexOfAny, Insert, Replace), Concatenation Operator (&), Comparison Operators (=, <, <=, >, >=, <>) Shared Method (Format).

5. Other Objects:
   Console: Shared Methods(ReadLine, Write, WriteLine)

   Graphics: Methods(DrawEllipse, DrawLine, DrawRectangle, FillEllipse, FillRectangle).

   Math: Shared Methods(Abs, Ceiling, Floor, Sqrt)

   SolidBrush: Pass in color to constructor.

   Pen: Pass in color or color and line width to constructor.

   Random: Methods(Next, NextDouble).

   StreamReader: Methods(Close, Peek, ReadLine)

   StreamWriter: Methods(Close, Write, WriteLine)

6. Controls: Label, TextBox, Button, CheckBox, RadioButton, GroupBox, ComboBox, TrackBar, PictureBox, ListBox, ComboBox, Menu, MenuItem.

7. File Processing: StreamReader, StreamWriter, ReadLine, Write, WriteLine, ControlChars.NewLine, Peek, Test for EOF, Split.

8. Events and Event Handlers:
   Control Events: Click, Enter, Leave.

   TextBox Event: TextChanged.

   ListBox and ComboBox Event: SelectedIndexChanged.

   TrackBar Event: Scroll.

   PictureBox Events: MouseDown, MouseMove, MouseOver, MouseEnter, MouseLeave, Paint.

   Form Events: Load, Activated, Deactivate, Close, Closed.

9. Drawing: Graphics Context, Color (Standard and FromArgb), Pen, SolidBrush, Font, DrawEllipse, DrawLine, DrawRectangle, DrawString, FillEllipse, FillRectangle, Invalidate.

10. Database OleDB Objects: OleDbConnection, OleDbCommand, OleDbDataAdapter, DataSet.

11. Method 2: Read from a database by creating the Connection, Command, DataAdapter, and DataSet objects dynamically in code. Use DataBindings to connect controls to columns in the DataSet.

12. Method 3: Read from a database by creating the Connection, Command, DataAdapter, and DataSet objects dynamically in code. Access data directly from the DataSet collections without using data bindings.

1. Answer multiple choice questions.

2. Answer short answer questions.

3. Write the Main method of a Console application that solves a problem.

4. Design an application to solve a problem, by explaining how to set the properties of controls on a form, and giving code for event handlers.

5. Read or write to a file using the StreamReader and StreamWriter objects.

6. Read from a database using Method 2 or Method 3.

7. Move data to or from these "data repositories": variables, array list, text box, combo box, picture box, (input from mouse clicks, output by drawing), message box, text file, database (read only).

8. Draw a simple picture in a picture box.