• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

Software Development Courses   Microsoft .NET Framework and Programming

M2389: Programming with Microsoft ADO.NET

View course dates

Course Duration: 3 days

Course Code: M2389

Course Description:

This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server™ 2000, and the Microsoft .NET Framework.

Prerequisites:

The course assumes that students have the following skills:



- Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
- Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
- Exposure to XML documents, style sheets, and schemas
- Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
- Experience building user interfaces, including Web applications or Microsoft Windows® applications

Relevant Certifications:

MCDBA: on Microsoft SQL Server 2000

MCAD: Microsoft Certified Application Developer

MCSD: for Microsoft .NET

This course includes the following modules:

Data-Centric Applications and ADO.NET

• Design of Data-Centric Applications
• ADO.NET Architecture
• ADO.NET and XML

Connecting to Data Sources

• Choosing a .NET Data Provider
• Defining a Connection
• Managing a Connection
• Handling Coonection Exceptions
• Connection Pooling

Performing Connected Database Operations

• Working in a Connected Environment
• Building Command Objects
• Executing Commands That Return a Single Value
• Executing Commands That Return Rows
• Executing Commands That Do Not Return Rows
• Using Transactions

Building DataSets

• Working in a Disconnected Environment
• Building DataSets and DataTables
• Binding and Saving a DataSet
• Defining Data Relationships
• Modifying Data in a DataTable
• Sorting and Filtering

Reading and Writing XML with ADO.NET

• Creating XSD Schemas
• Loading Schemas and Data into DataSets
• Writing XML from a DataSet

Building DataSets from Existing Data Sources

• Configuring a DataAdapter to Retrieve Information
• Populating a DataSet Using a DataAdapter
• Configuring a DataAdapter to Update the Underlying Data Source
• Persisting Changes to a Data Source
• How to Handle Conflicts

Building and Consuming a Web Service That Uses ADO.NET

• Building and Consuming a Web Service That Returns Data

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking or check availability.
Washington	3 days	£1060					14 - 16

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course