CS 32 Database Programming in Visual Basic .NET    3 Units
 

Transfer: UC, CSU  • Prerequisite: CS 15

 

Course Description:  This course is intended for students who successfully completed CS31 or CS15 or have a solid background in VB.NET, especially with creating classes and Exception Handling.  Students will learn how - using ADO - they can build applications in VB.NET that interface to database files and display data in Windows Forms. Students will learn the basics of Relational Database Design, SQL as a Query language to extract data, and how to use the ADO library in VB.NET to display data. Although the examples and assignments are for interfacing to MS Access and MS SQL server files, students who wish to interface to other database engines , such as Oracle, can still use the same code we cover in class.
Students will have access to SQL server, or given instruction on how to download and install MSDE.

CS31 or CS15 is a prerequisite to this class; students are not expected to have a background in database development, although use of some database applications such as Microsoft Access and Microsoft SQL Server is useful.

At the end of this course students would have developed a full fledged project that interfaces to the Northwind database file, with multiple forms and numerous capabilities for search and query.

Visual Studio 2003 Academic, will be provided Free of charge for students wishing to work at home, although it is their responsibility to install and maintain it.

 

Textbook
 
            Several textbooks are available for use; this recommended one covers a wide ground and provides detailed steps to the tasks needed to finish the hw's:

    •   Email for book info


        Schedule

          This is a tentative schedule of the topics to be covered.

Unit 1

Relational Database Design Basics

Unit 2

ADO Controls - OverView

Unit 3

Using Typed Datasets and Bound Controls

Unit 4

Using Typed Datasets and UnBound Controls

Unit 5

Using UnTyped DataSets and Bound Controls

Unit 6

Using unTyped DataSets and unBound Controls

Unit 7

Midterm 1

Unit 8

Using Views, and other Objects of ADO .NET

Unit 9

Using SQL Queries

Unit 10

Using Commands and Action Queries

Unit 11

Using Transactions and More SQL

Unit 12

Midterm 2

Unit 13

Using Server Explorer

Unit 14

Customizing Grid Controls

Unit 15

XML schema and Relations


 
Back