The Course Objective:
This course will teach the student how to develop VB.NET features such as storing and retrieving data,
using arrays, string manipulation, regular expressions, code reuse, and
functions. We will introduce Microsoft Access database showing you how to design, create, connect and work with databases and access them. This course is a prerequisite for
ASP.NET.
The Course Length: 32 hours
Prerequisite:
The student should be familiar with HTML and general Web development terminology. No previous ASP experience is required, but familiarity with the concepts behind interactive Web pages, including forms, scripts, and data access is a must.
Currently the course is offered to organizations and corporate employees.
| This course can be customized in accordance to your goal, your project, your background, and can be delivered at your location even for 1 employee. |

Lesson 1. The basics of VB.NET
This is an introduction to Object Oriented languages and the basics of VB.NET
- Introduction to Object Oriented Languages
- Introduction to .Net languages
- Variable data type and scope
- Arrays
- Conditional statements
- Looping Logic
- Procedures and Functions
- Classes
Lesson 2 and 3. Writing segments of code
In these lessons we will be working with the basics of VB.NET. The student will write the segments of code to demonstrate his/her understanding of the technique.
- Variable Declarations, Statements, Comments
- Accessing Indexed Properties, Declaring Indexed Properties
- Declaring Simple Properties
- Enumeration
- Declare and Use Methods
- Exception Handling
- String Concatenation
- Event Handler
- Casting
- Conversion
- Class Definition
- Implementing an Interface
- Class Definition with a Main Method
- Standard Module
Workshop
Write three short programs in VB.NET to show the following:
- The control structure and variables of VB.NET
- Write a program to demonstrate errors and error trapping techniques
- Write a VB.NET class; demonstrate how many ways can be used.
Lesson 4 and 5. Interfacing with databases
- Using Databases
- Quick introduction to databases and SQL
- ADO.NET
- Reading from Database Tables
- Inserting, Updating, and Deleting Database Records
Workshop
Use Microsoft Access to Create a database with two table one for invoice header and the other for the invoice detail
- Write a program to populate the invoice header and detail (at least three invoices)
- The program should trap any errors
- The program should Calculate the invoice total and update the header with the total amount
- The program should have the ability to update any line item. Can the program update the header?
- The program should have the ability to delete any line item or the invoice.
- The student should present the above as project and prove that the program works
|
|