office (678) 325-7317
fax (678) 325-7317
ADO.NET Programming

Course Length: 5 days or two 3 day classes


This course can be taught using either VB.NET or C# as a language. To present the database programming skills in a manageable progression, this course is divided into five sections.

Section 1: Introduction to ADO.NET programming
This section explains the background concepts and skills that you need for database programming with ADO.NET. If you’re new to database programming, this section is essential to getting started right.

Section 2: How to use data sources and datasets for RAD
This section shows you how to use data sources and datasets for prototyping and Rapid Application Development (RAD). These are the skills that will help you quickly develop working versions of database applications so they can be reviewed and enhanced.

Section 3: Three-layer Windows applications
This section shows you how to develop 3-layer applications that use presentation, business, and database classes. This is the approach that many professionals use because it applies a logical structure to database applications. You’ll also learn how to use object data sources in this section, because they can make this approach to application development even more effective.

Section 4: ADO.NET for web applications
Here, you’ll learn how to use ASP.NET data controls to develop web applications. That includes controls for both SQL and object data sources as well as controls that present data, like the GridView and DetailsView controls. These controls help you develop database-driven web applications faster and better than ever. And object data sources give you complete control over how the database processing is done.

Section 5: Advanced database programming skills
Last, you’ll learn advanced skills that every ADO.NET programmer should be aware of. These include how to work with XML, how to use the Report Designer to create reports, how to use the ReportViewer control to display reports in both Windows and web applications, how and why to use LINQ instead of SQL to query a database, and how to use the Entity Framework in combination with LINQ so you can work with objects and let the framework handle the database operations.

Who Should Attend?

This course assumes that you have basic Visual Studio and C# or VB.NET skills, the kind you should get from any core .NET programming course. If you don’t have all the core skills for developing real-world applications, we recommend you attend our C# or VB.NET programming course.

Course Outline

Section 1 An introduction to ADO.NET programming

Module 1 An introduction to database programming

Module 2 An introduction to ADO.NET

Section 2 How to use data sources and datasets for Rapid Application Development

Module 3 How to work with data sources and datasets

Module 4 How to work with bound controls and parameterized queries

Module 5 How to use the Dataset Designer

Section 3 Three-layer Windows Forms applications

Module 6 How to work with connections, commands, and data readers

Module 7 How to work with parameters and stored procedures

Module 8 How to work with transactions

Module 9 How to work with object data sources

Module 10 A complete Payable Entry application

Section 4 How to use ADO.NET with web applications

Module 11 How to use SQL data sources

Module 12 How to use the GridView control

Module 13 How to use the DetailsView control

Module 14 How to use object data sources

Section 5 Advanced database programming skills

Module 15 How to work with XML data

Module 16 How to use the reporting features of Visual Studio

Module 17 How to use LINQ

Module 18 How to use the Entity Framework

Home | AboutUs | Training | Mentoring | Contact Us

© 2008 Dunn Training Inc. All Rights Reserved.