Morad learning
|
|
Morad learning |
|
|||
|
|
|
|||
|
||||
|
|
||||
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 | ||||||||||||||||||||
Description |
. . |
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. |
||||||||||||||||||||
Outline |
. . |
Programming with ADO.NET 2.0 Course Goals Course Outline Audience Prerequisites 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 ADO.NET and XML 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. |
||||||||||||||||||||
Prerequisites |
. . |
Prior .NET experience is preferred, but not required. A working knowledge of Visual C# is assumed. |
||||||||||||||||||||
Features |
. . |
|
||||||||||||||||||||
|
|
|
||
|
