ADO.NET - CMP138

Course Description:

The ActiveX Data Objects (ADO) .NET is comprised of the Connection, Command, DataReader / DataSet, and DataAdapter objects. These objects will be used in various examples and classroom exercises to process data from a local database. Specific course topics include relational database structure, disconnected data, and Structured Query Language (SQL); a mixture of SQL queries of increasing complexity will be demonstrated using a SQL test program. A sample relational data base application will be used as an example to explain and demonstrate the adding, viewing, updating, and deleting of the data and the underlying relationships.

Prerequisites: Programming.NET Level II.

Technology update: Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.

Textbook:

Books may be purchased at the MC Bookstore or online. You will need to know the CMP#(Continuing Education classes) for the class you are taking in order to look up information about the textbook.

Classroom hours: 15
Course Objectives:

This course introduces the ADO .Net wizards and the ADO .Net objects. Emphasis is placed on the ADO objects and the disconnected dataset architecture of ADO .Net. The Connection, Command, Dataset, and DataAdapter objects are used to access and update local relational databases.

Course Outline: