CS 54 - Visual Basic .NET Programming I

Description

Intermediate Visual Basic .NET programming. Includes coverage of multitier applications, database applications, databases using related tables, database updates, using Web forms, Web forms database & updates, XML Web services, and writing database reports using Crystal Reports.

Prerequisites

Completion of CS 27 or equivalent.

Course Outcomes

Visual Studio .NET
1) Distinguish the features of the Visual Studio IDE versus the .NET Framework
2) Identify the purpose of each of the files listed in the Solution Explorer
3) Describe what happens at compile time
4) Discuss features from the VB6 compatibility library and why you should avoid them
5) Create an MDI project with a parent form, child forms, a toolbar, status bar, context menu, and ToolTips

Building Multitier Programs with Classes
1) Discuss object-oriented terminology
2) Design your own class and instantiate objects based on the class
3) Construct a new class based on an existing system class
4) Create and throw custom exceptions
5) Analyze the proper score for variables

Windows Database Applications
1) Explain the relationship of datasets, tables, rows, and constraints
2) Use MSDE to access SQL Server databases
3) Create and display information from a DataSet object
4) Describe how to bind a grid, a combo box, and labels to a database field
5) Design a multitier application, separating the data tier from the presentation tier

Windows Database Using Related Tables
1) Explain the types of table relationships
2) Describe how to display related tables using a DataGrid
3) Create a program to retrieve and display the parent row for a selected child row
4) Develop code that will display database fields in bound and unbound controls
5) Summarize the procedure for retrieving and displaying data from more than two related tables

Windows Database Updates
1) Modify a database table in a grid
2) Use the form's binding context to navigate records
3) Design an event handler and delegate for a component added in code
4) Describe how to add, edit, and delete records in bound controls on a form
5) Construct update statements to accurately update related tables

Using Web Forms - ASP.NET
1) Discuss concepts of Web-based applications
2) Distinguish among the various types of button controls
3) Describe the event structure used by Web applications
4) Evaluate Web input using the Validator controls
5) Explain how to maintain state (data values) from one page to the next

Web Forms Database
1) Determine when to use a data reader rather than a dataset
2) Summarize how to display data in a Web DataGrid
3) Create pagination for a grid
4) Use the CheckboxList and RadioButtonList controls
5) Construct a multitier Web application

Related Database Tables and Updates in Web Forms
1) Construct a program to display data from related tables on a Web Form
2) Explain how to edit, add, and delete records on Web Forms
3) Determine whether to use bound or unbound fields

Web Services
1) Discuss the concept of a Web service
2) Create a Web service
3) Design a program that consumes a Web service
4) Construct a Web service that performs calculations
5) Develop a Web service that accesses data

Writing Database Reports Using Crystal Reports
1) Create a Crystal Reports template and display the report from a Windows Form or a Web Form
2) Use advanced reporting functions, such as numeric functions, grouping, sorting, and special fields
3) Describe how to base a report on a data file or a dataset
4) Explain how to display a report at run time based on a user request

Faculty

Bill Cole (classroom, online)

Availability

This course is offered every semester, including summer, in either a traditional classroom setting or online.