Microsoft ADO.NET
Author:Mark Long / Certified Instructor
Language:english
Category:Programming,Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about 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.
Microsoft ADO_NETMicrosoft ADO_NET: To get started, simply click one of the topics belowListed below are all of the chapter and lesson contents for the Microsoft ADO_NET Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Microsoft ADO_NET freely available. Click on any of the linked lesson listings below to preview Free! Microsoft ADO_NET
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft ADO.NET

Course Introduction

Welcome
Course Overview
ADO.NET in Action-DataReader
ADO.NET in Action-DataSet

Overview of ADO.NET

ADO.NET Objectives
.NET Data Providers
Using Data Namespaces

ADO.NET Objects

ADO.NET Object Model
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

01 Course Introduction
0101 Welcome
0102 Course Overview
0103 ADO.NET in Action-DataReader
0104 ADO.NET in Action-DataSet

02 Overview of ADO.NET
0201 ADO.NET Objectives
0202 .NET Data Providers
0203 Using Data Namespaces

03 ADO.NET Objects
0301 ADO.NET Object Model
0302 Objects/Methods/Properties

04 Connecting To A Database
0401 Opening A Database Connection
0402 Using Error Handling
0403 Connection Status
0404 Using Trusted Security
0405 Connection String Variables
0406 Connecting to Access
0407 Using UDL Files
0408 Provider Gotchas
0409 Connection Miscellaneous

05 Executing Commands
0501 SQLCommand Object
0502 OleDbCommand Object
0503 Single Value Queries
0504 Parameterized Queries pt. 1
0505 Parameterized Queries pt. 2

06 Using Stored Procedures
0601 What is a Stored Procedure?
0602 Creating Stored Procedures
0603 Calling Stored Procedures
0604 Creating Stored Procedures with Parameters
0605 Passing Parameters to Stored Processes
0606 Transactions pt. 1
0607 Transactions pt. 2

07 DataReader
0701 DataReader Basics
0702 Using a DataReader
0703 Multiple Result Sets in a DataReader
0704 Reading Schema from a DataReader

08 DataAdapter
0801 DataAdapter Basics
0802 Using the DataAdapter
0803 Inserting Data with CommandBuilder pt. 1
0804 Inserting Data with CommandBuilder pt. 2
0805 Updating Data with CommandBuilder
0806 Deleting Data with CommandBuilder

09 DataSet
0901 DataSet Basics
0902 Typed DataSets
0903 Creating a DataSet
0904 DataTables
0905 DataRows
0906 DataColumns
0907 DataViews

10 Data Binding
1001 What is Data Binding?
1002 Data Bound Textboxes
1003 Life without Cursors
1004 Navigating with Binding Objects pt. 1
1005 Navigating with Binding Objects pt. 2
1006 Navigating with Collections pt. 1
1007 Navigating with Collections pt. 2
1008 Complex Binding

11 XML & ADO.NET
1101 XML Basics
1102 XML Terminology
1103 XML and .NET
1104 Reading XML Data
1105 Putting XML in DataSets
1106 Writing XML from a DataSet
1107 Much More XML

12 What About ADO?
1201 Using ADO

13 DataForm Wizard
1301 DataForm Wizard Basics
1302 Best Use for DataForm Wizard

14 Background Info
1401 Data Access TLAs

15 Credits
1501 About the Author

Sponsors