Download
1 / 19
190 likes | 210 Views
Join our review session covering topics on classes, objects, control structures, methods, arrays, LINQ, files, strings, and databases in Visual Basic. Prepare with textbook readings, practice exercises, and programming tasks.
E N D
CSCI 3327 Visual Basic Review: Final Exam UTPA – Fall 2011
Review • Textbook • Self-Review Exercises • Quick Quiz • Exercises • Time • 10:15 a.m.-12 p.m., Dec. 16 (Friday) • Place • ENGR 1.272 (classroom)
Review • Lecture slides • Introduction to Classes and Objects • Control structure • Methods • Arrays • LINQ • Files and Streams • Strings • Databases and LINQ
Review • Multiple Choice • True/False Statements • Programming • Write the code • Bonus Question
Chapter 3: Introduction to Classes and Objects • Objects • Object-oriented design & programming • Classes • The Syntax for a Class • Variables • Methods • Subroutines vs. functions • Properties • Set and Get methods • Events • Relationships between classes and objects
Chapter 4: Control Structure (Part I) • The primitive data types • Arithmetic operators & Precedence • +, -, *, /, \, Mod • The components of basic control structures • The syntax of basic sequence, selection, and repetition structures in Visual Basic
Chapter 5: Control Structure (Part II) • More control structures • Repetition statements • For … Next, Do … Loop While, Do … Loop Until • Usage of Exit and Continue statements • Selection • Select … Case • Logical operators
Chapter 6: Methods • Classification and declaration of methods • Subroutines • Functions • ByVal vs. ByRef parameters in methods
Chapter 7: Arrays • Declaration and usage of arrays • Index/subscript • Length, GetUpperBound() • Initialization and reference to elements of the array • Usage of the For Each … Next statement to iterate through elements in the array
Chapter 7: Arrays (cont'd) • Search • Linear search • Binary search • The declaration and usage of rectangular arrays • Index/subscript
Chapter 8: Introduction to LINQ and Collections • Write filtering statements using LINQ • The usage of LINQ to query an array • Sort an array using LINQ • Ascending • Descending
Chapter 9: Object-Oriented Programming: Classes and Objects • Declaration of classes • Declaration of properties and their methods • Set and Get • Exercises
Chapter 11: Files and Streams • Data Hierarchy • Bits Characters Fields Records File • Create a File • Dim fileWriter As StreamWriter=New StreamWriter(fileName) • Dim fileReader As StreamReader=New StreamReader(fileName) • Write a File • fileWriter.WriteLine(“text”) • Read a File • Dim oneline As String = FileReader.ReadLine() • Close a File • fileWriter.Close()
Chapter 12: Strings, Characters and Regular Expressions • Declaration and initialization of a String object • Dim string1 AsString = "Hello" • String Property • string1.Length • String Indexer • string1(i) • i is index from 0 to string1.Length-1
Chapter 12: Strings, Characters and Regular Expressions (cont'd) • String Methods • string1.Equals(“hello”) • String.Equals(string1, string2) • string1.CompareTo(string2) • If string1 < string2, -1 • If string1 > string2, 1 • If string1 = string2, 0 • string1.StartWith("st") • string1.EndWith("st")
Chapter 13:Databases and LINQ • Create a connection between data source and controls • Display the results of the LINQ query • How to update the database via controls
Good Luck! Q/A
