ADO.NET Step By Step Webcast Series

This webcast series is devoted to those who want to learn to really use ADO.NET. Learn from Lindsay Rutter and Glen Gordon, featured speakers for Microsoft.
This webcast series is devoted to those who want to learn to really use ADO.NET. Learn from Lindsay Rutter and Glen Gordon, featured speakers for Microsoft.
Webcasts In This Series
––––––––––––––––––––––––––––––––––––––––
05/09/2007 - Part 1 of 16: Getting Started
ADO.NET—the data-access component of the Microsoft .NET Framework—works with any component on any platform that understands XML. Get a solid handle on ADO.NET and learn how to exploit the database functionality of Microsoft Visual Basic� .NET and Microsoft Visual C#™ .NET with this step-by-step primer. You’ll be working in ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn about the ADO.NET object model and how to use it to develop data-bound Windows� Forms and Web Forms. See how ADO.NET interacts with XML and how to access older versions of ADO from the .NET environment. Throughout, you’ll find insightful tips and expert explanations for rapid acceleration of development productivity, faster applications, and more powerful results. This webcast will cover the first chapter of the book, where we will examine the ADO.NET Object Model and see an example of binding data to a simple Windows Form.
05/16/2007 - Part 2 of 16: Creating Connections
This chapter examines connections to data: how they are made, properties of a connection, methods available for manipulating connections and handling events raised by connections.
05/23/2007 - Part 3 of 16: DataCommands and the DataReader
This session will cover a basic foundational element in ADO.NET: the DataReader. We will examine how recordsets from databases are retrieved using the DataReader and how the data can be manipulated by commands.
05/30/2007 - Part 4 of 16: The DataAdapter
The DataAdapter faciliates the communication between the DataSet and database, and provides methods to select, insert, update and delete data that has been changed to added to the database.
06/06/2007 - Part 5 of 16: Transaction Processing in ADO.NET
This chapter focuses on transaction processing. We’ll examine how to create a transaction, created a nested transaction, commit these transactions and rollback transactions if needed.
06/13/2007 - Part 6 of 16: Modeling a Database by Using DataSets and DataRelations
Now that we have gotten familiar with the ADO.NET Data Providers, this chapter starts to examine the Data Objects we will use to manipulate data in our applications. The first object we’ll explore is the DataSet. We’ll see how to create DataSets, add DataTables and DataRelations to DataSets and how to clone and copy DataSets.
06/20/2007 - Part 7 of 16: Using DataTables
Though we’ve been exposed to DataTables earlier in this series, we’ll take this session to examine them more closely. This webcast will examine the structure, properties and methods of DataTables.
06/27/2007 - Part 8 of 16: Using TableAdapters
This chapter will examine the TableAdapter class in detail. We will create a TableAdapter class and a TableAdapter object and configure them.
THURSDAY - 07/05/2007 - Part 9 of 16: Using DataViews
The DataView provides a way to filter and sort DataRows at design time. This chapter will take a look at how to add a DataView to a form and use it to examine and view our data in our application.
07/11/2007 - Part 10 of 16: Editing and Updating Data
Now that we’ve been introduced to the objects of ADO.NET, we will start to take a look at how these objects work together to perform specific tasks. This chapter will concentrate on editing and updating data using the previously examined objects.
07/18/2007 - Part 11 of 16: Manual Data Binding in Windows Forms and Data Binding in Windows Forms by Using the BindingSource Component
This webcast will cover chapters 11 and 12 of the book and cover how to bind data to our Windows Forms. First we will examine the underlying mechanisms used to bind controls to ADO.NET data sources. Secondly, we’ll explore the BindingSource class, new to ADO.NET 2.0, which acts as an intermediary between a data source and Windows Forms controls – simplifying and extending the data-binding process.
07/25/2007 - Part 12 of 16: Using ADO.NET in Windows Forms
Extending the previous session of how to bind data sources to our Windows Forms, we’ll explore using this newly introduced functionality to perform some common tasks like formatting data, displaying related data and working with events.
08/01/2007 - Part 13 of 16: Basic Data Binding in Web Forms and Data Binding in Web Forms by Using the Data Source Component
Here we will look at binding data in Microsoft ASP.NET and Web Forms with ADO.NET objects. We will also examine the Data Source controls new to the .NET Framework 2.0 making it possible to bind to data with very little code.
08/08/2007 - Part 14 of 16: Data-Bound and Validation Controls
This session covers the data-bound Web Form controls that are designed to work with .NET 2.0 Data Source controls that also work with ADO.NET objects. Secondly, we will examine the ASP.NET validation controls that provide an elegant solution to handling data entry errors.
08/15/2007 - Part 15 of 16: Reading and Writing XML and the XmlDataDocument
The next 2 chapters focus on the interaction between ADO.NET and Extensible Markup Language (XML). We will take a look at the structure of an XML schema and the DataSet methods that allow us to read and write data from and XML data stream. Then will will examine the XmlDataDocument that provides and XML view of the data in a DataSet.
08/22/2007 - Part 16 of 16: Part 16 of 16: Using ADO and ADOX in the .NET Framework
The last webcast in this series wraps up with some real-world uses of ADO.NET: working with data objects created with previous versions of ADO and examining the Microsoft ADO Extensions for DDL and Security (ADOX) library.
Download
Mirror