Programming in Visual Basic with Oracle

Objective:
The course is designed with an objective to
 Introduce programming concept in Visual basics and oracle.
 Enable students to design database.
 Enable students to design new techniques for software development.
 Enable students to learn database connectivity using Visual Basic as front-end tool.

Learning Outcome:
On completion of the course, students will be able to
 Analyze and manipulate data from a large database
 Formulate new and better data accessing techniques
 Develop better user friendly software
 Student can use SQL for storing and retrieving data from the RDBMS.

Unit I: 10L
GUI Environment: Introduction to graphical user interface (GUI), programming language
(procedural, object oriented, event driven), the GUI environment, compiling, debugging, and
running the programs.

Unit II: 12L
Controls: Introduction to controls textboxes, frames, check boxes, option buttons, images,
setting borders and styles, the shape control, the line control, working with multiple controls and
their properties, designing the user interface, keyboard access, tab controls, default & cancel
property, coding for controls.

Unit III: 6L
Operations: Data types, constants, named & intrinsic, declaring variables, scope of variables,
val function, arithmetic operations, formatting data.

Unit IV: 9L
Decision Making : If statement, comparing strings, compound conditions (and, or, not), nested
if statements, case structure, using if statements with option buttons & check boxes, displaying
message in message box, testing whether input is valid or not.

Unit V: 8L
Forms and Iteration Handling : Multiple forms creating, adding, removing forms in project,
hide, show method, load, unload statement, me keyword, referring to objects on a different
forms, Do/loops, for/next loops, using msgbox function, using string function

Unit VI: 15L
Oracle: Approach and advantages, PL/SQL blocks variable, manipulating data, Input and
Output Parameters and Return values, Exception handling, procedure, function, package,
triggers.

Books Recommended:
1. Bradley, J. C., Millispangh A. C. ,: “Programming in Visual Basic 6.0” , Tata Mcgraw
Hill Edition 2000 (Fourteenth Reprint 2004).
2. Bayross, I, : “SQL, PL/SQL the Programming Language of Oracle”, Paperback – 1 Dec
2010.
3. Petroutsos, E. : “Mastering Visual Basic 6 ” , BPB , ISBN: 9788126523085, Edition: 6th,
2009.
4. Jerke, N.: “Visual Basic 6: The Complete Reference” 1st Edition.
Computer Lab Based on Visual Basic with Oracle:
 Practical exercises based on concepts listed in theory using VB.

Discussion:
 Hands on practice on installation, connection ,SDLC
 Table definition (The table must include constraints)