Morad learning

Home | About Us | Purchase Courseware Online | Services | .NET Courses | Register for Online Classes! | XML Courses | Contact Us

Programming with ADO.NET 2.0

Class Duration


5 days.

Delivery Mode


Face-to-face Instructor-led in a community-of-practice environment.

Goals of the Course


Everything you need to learn and practice to access data in your .NET 2.0 applications. This course covers connected and disconnected modes of data access using the various ADO.NET 2.0 objects like DataReaders, DataSets, and DataTables, Data Binding in both Windows Forms or Web Forms, and handling XML data. The emphasis is on the Visual Studio 2005 and the ADO.NET 2.0 technologies and not on the specific programming language used (either Visual C# or Visual Basic) Although the course is taught via Visual C# 2005.

Course Name


Programming with ADO.NET 2.0



Microsoft designed the ADO.NET 2.0 technology, as part of its overall .NET 2.0 strategy, to provide a very powerful platform for accessing, retrieving, and manipulating data in either Windows Form Applications or Web Form Applications. To master development in this new data access environment, a programmer must be equipped with the necessary ADO.NET 2.0 knowledge and skills. This is what this course provides. It provides a thorough introduction to the ADO.NET 2.0 technology, how it works, and how to apply it in your applications using the VS 2005 IDE. The course is taught via Visual C# 2005.

The course describes in detail the ADO.NET Object Model and explains how the various ADO.NET objects work together to access data. Some of the topics covered include patterns of using the ADO.NET object model, the Connetion Object, the Command Object, the DataReader Object, the DataAdapter Object, the TableAdapter, and the DataSet Object.

The instructional strategy for this course emphasizes project-based learning, practical real-life problem solving skills, and getting started with ADO.NET 2.0 programming using VS 2005 as quickly as possible.




Programming with ADO.NET 2.0
Course Goals
Course Outline

An Introduction to ADO.NET
The ADO.NET 2.0 Framework
Data Access Layer (DAL)
Connected vs. Disconnected DAL
Stored Procedure vs Dynamic SQL Statement
Entity Objects vs Business Objects

The ADO.NET Object Model
ADO.NET Object Model
Connected Mode DAL
Disconnected Mode DAL
Data Adapters
Table Adapters

Establishing a Connection to a Data Source with the Connection Object
DAL Connections
The Connection Object
Connection Strings
Connection Pools
Examining Connections

Executing Database Commands with the Command Object
The Command Object
Types of Commands
Setting Commands Parameters
Executing Database Commands
Creating DataReaders
Reading Data from a DataReader

Modeling Database Operations in a Disconnected Mode with the DataSet Object
The DataSet Object
Untyped vs Typed DataSets
Creating DataSets
Configuring DataSets
DataSet Methods
Creating Data Relations
Configuring Data Relations
Using the Data Adapter to Manage Typed DataSet

Modeling Database Table Operations in a Disconnected Mode with the DataTable Object
The DataTable Object
Why DataTable
Creating DataTable
Configuring DataTables
Primary Key Constraints
The DataColumns Object
Adding Constraints
Creating DataRows
DataTable Methods

Filtering and Sorting DataTables with the DataView Object
The DataView Object
Why DataViews
Creating DataViews
Configuring DataViews
Sorting & Filtering Data with DataViews
Binding to DataViews

Creating Business Objects with the TableAdapter Object
The TableAdapter Object
Creating TableAdpaters
Configuring TableAdapers Classes
Configuring TableAdapter Objects
The TableAdapter Methods

Manually Binding Data to Windows Forms
Data Binding in Windows Forms
Binding Controls to DataSources
Simple Binding
Complex Binding
Binding Context
The CurrencyManager Object
The Binding Object

Automatically Binding Data to Windows Forms with the BindingSource Object
The BindingSource Object
Creating a BindingSource Objects
Configuring the BindingSource Object
The BindingSource Object
The BindingNavigator Object

Manually Binding Data to Web Forms
Data Binding in Web Forms
Simple Binding in Web Forms
Complex Binding in web Forms
ADO.NET Object State
Navigating Data in Web Forms
Updating the DataSource

Automatically Binding Data to Web Forms with the DataSource Object
The DataSource Object
Creating DataSource Objects
Configuring the DataSource Objects
DataSource Objects Methods

Reading & Writing XML Data
DataSet & XML
Reading XML into a DataSet
Writing XML from a DataSet

Manipulating DataSet data as XML with the XmlDataDocument
The XMLDataDocument
Navigating a DataSet as an XML Document
Using XPath
Coordinating DataRows & XMLDataDocument Elements


Who Should Attend?


Programmers and developers who want to become proficient with the ADO.NET 2.0 technologies.



Prior .NET experience is preferred, but not required. A working knowledge of Visual C# is assumed.



bullet ABC Format. A=Accurate, B=Brief, C=Complete
bulletUtilizes Microsoft Press books and references
bulletLearning is focused on real-situation problem solving
bulletSound instructional design strategies
bullet Learn-by-doing course design philosophy
bullet Clear explanations of concepts and principles
bullet Emphasis on getting started quickly
bullet Many examples and worked out samples
bullet Online Learning Environment (OLE) always accessible during class period from any location even across firewalls
bullet Learning Tools (LTs) supporting the learning process

Home | Up | About Us | Purchase Courseware Online | Services | Register for Online Classes! | XML Courses | Contact Us