|
Standard |
CIS 1122 – Visual Basic.NET II
Course Description:
Advanced Visual Basic.NET teaches client-server systems, n-tier development environments, relational databases, use of SQL to access data, the use of ADO.NET objects, methods and properties to access and update relational and XML databases. Advanced features of Visual Basic are explored.
|
Competency
Areas: |
Hours: |
||
|
|
|
|
|
|
Methods
of Data Storage |
Class |
4 |
|
|
Use of
SQL to access data |
D. Lab |
6 |
|
|
ActiveX
Data Objects ( |
P. Lab/O.B.I. |
0 |
|
|
Data
Providers and datasets |
Credit |
7 |
|
|
Wizards
available for connections and commands |
|
|
|
|
Typed
Datasets and bound controls |
|
|
|
|
Untyped
datasets and bound controls |
|
|
|
|
Validating
and Updating Data |
|
|
|
|
Data
views and parameterized queries |
|
|
|
|
|
|
|
|
|
Prerequisite:
CIS 1121,
CIS 124 or CIS 2128 |
|||
|
Corequisite: |
|
||
|
Course Guide |
|
Competency |
After completing this section,
the student will: |
Hours |
||
|
Class |
D. Lab
|
P. Lab/ O.B.I. |
||
|
|
|
|
|
|
|
METHODS OF DATA
STORAGE |
4 |
8
|
0 |
|
|
|
Understand
the differences between client/server systems, n-tier environments, and
distributed data using XML format |
|
|
|
|
USE OF SQL |
4 |
8
|
0 |
|
|
|
Be able
to write simple SQL statements to retrieve, update, add and delete data to
existing databases |
|
|
|
|
ACTIVEX DATA OBJECTS |
4 |
8
|
0 |
|
|
|
|
|
|
|
|
4 |
6
|
0 |
||
|
|
Attain an
appreciation for the object model using data providers specific to individual
data sources such as SQL Server, Oracle, Access and other ODBC compliant
databases |
|
|
|
|
USE OF WIZARDS |
4 |
6
|
0 |
|
|
|
Be able
to use the available Wizards in Visual Basic to establish connections with
databases and create command objects |
|
|
|
|
TYPED DATASETS AND BOUND CONTROLS |
4 |
6
|
0 |
|
|
|
Be able
to bind controls to typed (XML) datasets |
|
|
|
|
UNTYPED DATASETS AND BOUND
CONTROLS |
6 |
6
|
0 |
|
|
Appreciate
the complexities and challenges of using data without predetermined
schemas. |
|
|
|
|
|
Achieve a
fundamental ability to access untyped data |
|
|
|
|
|
VALIDATING AND UPDATING DATA |
4 |
6
|
0 |
|
|
Be able
to use the Visual Basic tools to validate that data conforms to the schema of
a specific database, and be able to update remote databases with locally
derived data |
|
|
|
|
|
6 |
6
|
0 |
||
|
Comprehend
views comprised of subsections of distinct tables, and be able to write
queries using parameters |
|
|
|
|
|
Suggested Resources |
Books:
Ekedahl and Newman, Visual Basic.NET, an Object Oriented Approach, Course Technology
2002
Prince and Lowe, VB.NET Database Programming with ADO.NET,
Mike Murach and Associates, 2003