 |  | 
In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts , and more.
In this course, you will learn to:
Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
Retrieve data, using the DataAdapter, Command, and DataReader classes
Create and configure Command parameters
Cache data using the DataTable and DataSet classes
Apply constraints to DataTable and DataColumn objects
Create relations between DataTable objects, using the DataRelation class
Update data using DataAdapter and Command classes
Work with strongly typed DataSet and DataTable classes
Retrieve and update data using TableAdapter classes
Handle exceptions and data errors, including concurrency errors
Search, sort, and filter data using the DataView class
Work with auto-increment columns in multi-user applications
Retrieve and generate XML data
Take advantage of new SQL Server 2005 features
Your Instructors
Ken Getz is a nationally renowned speaker and best-selling author who specializes in programming with Visual C# and Visual Basic. He has been working with AppDev for more than 10 years, and is the author and presenter of some of AppDev's most popular courses. Ken is also a senior consultant with MCW Technologies and the author or co-author of several best-selling books including Access 2002 Developer's Handbooks (with Paul Litwin and Mike Gunderloy (Sybex)), Access Cookbook (with Andy Baron and Paul Litwin (O'Reilly)), VBA Developer's Handbook (with Mike Gilbert (Sybex)), and ASP.NET Developer's JumpStart (with Paul D. Sheriff (Addison-Wesley)). Since the inception of the program, Ken has been selected each year as a Microsoft Support MVP and is a member of the INETA speaker's bureau, traveling to speak at .NET user groups throughout the country. Ken is a frequent speaker at technical conferences, including Microsoft's Tech-Ed, as well as VSLive and DevConnections. Ken is also a technical editor for Advisor Guide to Microsoft Access and Advisor Guide to Microsoft Visual Basic and is a columnist for both CoDe Magazine and MSDN Magazine.
Andy Baron is a nationally recognized industry expert specializing in Visual Basic, Visual C#, ASP.NET, ADO.NET, SQL Server and SQL Server Business Intelligence. He has authored and presented more than 15 Visual Studio and SQL Server courses for AppDev. Andy is also Senior Consultant with MCW Technologies, as well as a contributing editor for Advisor Media and Pinnacle Publications, a writer for SQL Server Magazine, and co-author of the Microsoft Access Developer's Guide to SQL Server. Since 1995, Andy has been selected each year as a Microsoft MVP for his contributions to Microsoft's online support. Andy also speaks regularly at industry conferences.
Course Outline
Accessing Data with ADO.NET
The ADO.NET Object Model
Connecting to Data
Understanding Connection Pooling
Using Provider Statistics
Retrieving Data
Introducing Command Classes
Working with Data Readers
Digging Deeper into Commands and DataReaders
Caching Data in DataSets
Populating a DataTable
Filling DataSets Using a DataAdapter
Using the Load Method
Retrieving Schema Information
DataSets and XML
Applying Constraints
Using Constraints
Foreign Key Constraints
Other Constraints
Data Relations
Creating DataRelations
Navigation Pathways
Expressions and Relations
Specifying XML Nesting
Updating Data
Creating Commands with CommandBuilders
Creating Custom Commands
Using Stored Procedures
Performing Batch Updates
Using Strongly Typed DataSet Classes
Using a Loosely Typed DataSet
Creating a Strongly Typed DataSet
Using a Strongly Typed DataSet
Issues with Using a Strongly Typed DataSet
Using Structured Exception Handling
Handling Provider Errors
Using Transactions
Handling Concurrency Conflicts
Searching, Sorting, and Filtering
The Sample Project
Working with DataTables
Working with DataViews
Handling AutoIncrement Columns
The AutoIncrement Property
Retrieving New Database Values
Avoiding Multi-User Conflicts
Merging Inserted Rows
Other Considerations
XML Techniques
ADO.NET and XML
Saving DataSet Data as XML
Loading XML Data into a DataSet
Working with DataSets and XML Together
Working with XML Data in SQL Server
Features Supporting SQL Server 2005
Enumerating Servers on a Network
Asynchronous Processing
Multiple Active Result Sets (MARS)
Bulk Copy Operations
SQL Server Max Data Types
SQL Server User Defined Types
SQL Server Snapshot Isolation
|
|
**Register Today and Save $$ with Planetlearn.com**
Enter your email address and receive... - FREE coupon good for 10% off all online purchases..
- FREE newsletter with exclusive offers on cbt training.
- FREE Email Job Alerts provided by 10millionjobs.com.
| Join today and save! Enter your email address. |
|
|
Prices are for single user. If you are looking for internet/intranet or LAN solutions and have specific training needs not listed, please call 207-671-1666 or E-Mail sales@planetlearn.com
Partner Sites
www.10millionjobs.com
SAP Top Sites.com - Vote for Us!
Planetlearn
107 Elm Street Suite 205G
Portland, ME 04101
207-671-1666
Press Ctrl+ D to bookmark this page. Order securely online or call 207-671-1666
Office hours: Monday - Friday, 9am to 5pm Eastern Standard Time |
|
