Objectives
This
course will provide delegates with a sound base in programming for the ADO.NET
for the new Microsoft .NET Framework using either C# or VB.NET. Delegates will
gain experience of programming using both C# and VB.NET.
Course Content
Course content has been developed for real-world, commercial scenarios by our
expert instructors. See below for detailed syllabus, or if you have a technical query email .
You will learn how to :
Utilise Visual Studio .NET to develop and debug applications
Understand the ADO.NET architecture
Understand the roles of the ADO.NET objects
Use data binding to present data
Use Commands to access and update data
Hands on Exercises
The
course will contain a substantial amount of Hands-On work. Delegates will be
introduced to topics during theory sessions and these will be followed by lab
exercises relating to the topic. Delegates will work on exercises using either
the VB.NET or C# languages, using the Visual Studio.NET development environment.
Exercises will reflect commercial scenarios.
Duration
3 days
Who Should Attend
Developers
who wish to create commercial ADO.NET applications and web services, and to
sample both C# and VB.NET languages.
Pre Requisite Skills
Experience
of programming VB.NET or C# and ideally of Object Oriented Programming.
ADO.NET Objectives and Architecture, Client Cursors and Server Cursors, Disconnected and Connected Data Programming, ADO.NET compared to 'classic' ADO, DataSets, Benefits of ADO.NET
The SQL and OLE DB Managed Providers, Connection, Command and DataReader objects, DataAdapters, Parameterised Commands, Using Stored Procedures
An understanding of SQL and relational databases, Data Definition Language
Working with DataSets, Loading DataSets using XML, Loading DataSets using Managed Providers, The DataSet Object Model, DataSet Navigation, Sorting and Filtering, DataViews, Using Data Relationships, Using Stored Procedures
ADO.NET Data binding compared to classic ADO Data binding. Binding to Windows Forms, Binding to Web Forms, Using TableMappings
Performing Updates using Command objects,
Performing Updates using DataSets, Concurrency Issues when using DataSets and
DataAdapters, Controlling the Order of Updates, Programming Custom Updates,
Using Transactions
Using Server Explorer, Database Design Tools, Visual Data Objects
Benefits of Typed DataSets, Creating XML Schemas, Creating and Customising Typed DataSets, Using Typed DataSets
.NET 3.0 Windows Presentation Foundation - WPF Training Course
.NET 3.0 Windows Communication Foundation - WCF Training Course
.NET 3.0 Windows Workflow Foundation - WF Training Course
.NET 3.0 Technology Overview
ASP.NET 3.5 Training Course with Visual Studio 2008, ASP.NET AJAX, and Silverlight
Silverlight for Developers Training Course
Silverlight for Designers Training Course
.NET 2.0 & 3.0 Programming with Visual Studio 2008 (C# / VB)
C# 3.0 Programming Training Course (C#3 Training Course)
Visual Basic 9.0 Programming Training Course (VB9 Training Course)
ASP.NET 2.0 training course
Advanced ASP.NET 2.0 with AJAX training course
Creating Commercial Server Controls with ASP.NET 2.0
.NET 2.0 Programming with C# and VB.NET
.NET 2.0 Multi-threaded Programming with C# and VB.NET for dual/multi-core training
.NET Design Patterns & Architecture Training UK
Secure coding with .NET
Testing with Visual Studio Team System Training UK
C#.NET 2.0 Smart Device Development with .NET Compact Framework Training UK
Visual Studio 2005 training
.NET Framework 2.0 Training
.Net Seminar - Overview for managers and developers
SharePoint 2007 Applications Development Training UK
BizTalk Server 2006 Training UK
ADO.NET Programming Course