Training Design Tutoring Guidance Computer Help Online Computer Help Help Technology Learning Online Computers Guidance Help Business Lessons Training Workstation Guidance
Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Support Business Advice Lessons Laptop Education CDs Webmaster Learning Online Adobe Tutorials Help Certification Advice Learning Design Guidance Education Word Tutoring

Microsoft ADO.NET Training

More Microsoft ADO.NET Categories Programming training - Database training - Microsoft training -
Microsoft ADO.NET Tutorials Online
Product Microsoft ADO.NET Details
Total Time : 5.00 hrs
Number of Movies : 67
Number of Discs : 1
Catalogue Number : 33480
Language : english
Author : Mark Long
Sale Price : $99.95

Purchase Below




View simillar products Programming training - Database training - Microsoft training -
Description Microsoft ADO.NET
ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately, or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results can be presented to the database users in any number of ways. In this tutorial, Mark Long shows you, step by step, how to take advantage of ADO.NET?s functionality to enhance your network?s productivity. To get started today, simply click one of the movie topics below.
Sample - Preview the First 3 chapters of Microsoft ADO.NET video free. Free learning Microsoft ADO.NET online.

Course Introduction
movie image Welcome
movie image Course Overview
movie image ADO.NET in Action-DataReader
movie image ADO.NET in Action-DataSet

Overview of ADO.NET
movie image ADO.NET Objectives
movie image .NET Data Providers
movie image Using Data Namespaces

ADO.NET Objects
movie image ADO.NET Object Model
movie image Objects/Methods/Properties

Connecting To A Database
Opening A Database Connection
Using Error Handling
Connection Status
Using Trusted Security
Connection String Variables
Connecting to Access
Using UDL Files
Provider Gotchas
Connection Miscellaneous

Executing Commands
SQLCommand Object
OleDbCommand Object
Single Value Queries
Parameterized Queries pt. 1
Parameterized Queries pt. 2

Using Stored Procedures
What is a Stored Procedure?
Creating Stored Procedures
Calling Stored Procedures
Creating Stored Procedures with Parameters
Passing Parameters to Stored Processes
Transactions pt. 1
Transactions pt. 2

DataReader
DataReader Basics
Using a DataReader
Multiple Result Sets in a DataReader
Reading Schema from a DataReader

DataAdapter
DataAdapter Basics
Using the DataAdapter
Inserting Data with CommandBuilder pt. 1
Inserting Data with CommandBuilder pt. 2
Updating Data with CommandBuilder
Deleting Data with CommandBuilder

DataSet
DataSet Basics
Typed DataSets
Creating a DataSet
DataTables
DataRows
DataColumns
DataViews

Data Binding
What is Data Binding?
Data Bound Textboxes
Life without Cursors
Navigating with Binding Objects pt. 1
Navigating with Binding Objects pt. 2
Navigating with Collections pt. 1
Navigating with Collections pt. 2
Complex Binding

XML & ADO.NET
XML Basics
XML Terminology
XML and .NET
Reading XML Data
Putting XML in DataSets
Writing XML from a DataSet
Much More XML

What About ADO?
Using ADO

DataForm Wizard
DataForm Wizard Basics
Best Use for DataForm Wizard

Background Info
Data Access TLA's

Credits
About the Author