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

Ken Getz is a nationally renowned speaker and best-selling author who specializes in programming with Visual C# and Visual Basic. He is the author and presenter of some of 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 . 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.